Tables that have nothing in common

  • Thread starter Thread starter Adam
  • Start date Start date
A

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
 
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];
 
Back
Top