ACCESS Lesson 116 - UNION SQL

how to do an SQL UNION of 2 tables in Microsoft Access SQL (Structured Query Language)

THIS IS THE UNION QUERY IN MS ACCESS SQL:

SELECT
"Player" as RecType,
PLAYERS.[PlayerID] AS ID,
1000000 + PLAYERS.[PlayerID] AS UNIQUEID,
"" AS FirstName,
PLAYERS.[LastName]
FROM PLAYERS

UNION SELECT
"Person" as RecType,
tblPERSONS.[PersonID] AS ID,
2000000 + tblPERSONS.[PersonID] AS UNIQUEID,
tblPERSONS.[FirstName] AS FirstName,
tblPERSONS.[LastName]
FROM tblPERSONS;

englishspacedog YouTube tutorial from Canada
http://www.herostratus.ca/PC.htm


Видео ACCESS Lesson 116 - UNION SQL канала MS / Access