Tables that have nothing in common

[Adam]

How can I have the three separate Tables that have nothing in common? I want
to combine them into one column? How can I do this?

Example:
[123WeeklyAdminData].emp_name,
[123WeeklyCallbackData].emp_name
[123WeeklyRecruitData].emp_name

Adam

 

[KARL DEWEY]

Use this union query --
SELECT [123WeeklyAdminData].emp_name, "Admin" AS Type
FROM [123WeeklyAdminData]
UNION ALL SELECT [123WeeklyCallbackData].emp_name, "Callback" AS Type
FROM [123WeeklyCallbackData]
UNION ALL SELECT [123WeeklyRecruitData].emp_name, "Recruit" AS Type
FROM [123WeeklyRecruitData];