Querie from table.

[Krefty]

Below I have a querie that I have added 'Special
Instructions'.

What this query does is brings Office Location, First and
Last Name, and Standby Status to a report so that from the
5 differanct tables I can see anyone that has been
selected for "Service Standby" or "Supervisor OnCall". I
want to continue to see any employee selected for Standby
or OnCall, BUT I would also like to see any Special
Instructions for those employees that come back with
Standby or OnCall Status.

Can you help.

Here is what I attempted but it did not work.


SELECT OfficeLocation,[Standby
Status],LastName,FirstName,'Special Instructions'
FROM [Southern Employees]
WHERE [Standby Status] In ("Service Standby", "Supervisor
OnCall")
UNION
SELECT OfficeLocation,[Standby
Status],LastName,FirstName, 'Special Instructions'
FROM [Central Employees]
WHERE [Standby Status] In ("Service Standby", "Supervisor
OnCall")
UNION
SELECT OfficeLocation,[Standby
Status],LastName,FirstName, 'Special Instructions'
FROM [Eastern Employees]
WHERE [Standby Status] In ("Service Standby", "Supervisor
OnCall")
UNION
SELECT OfficeLocation,[Standby
Status],LastName,FirstName, 'Special Instructions'
FROM [Western Employees]
WHERE [Standby Status] In ("Service Standby", "Supervisor
OnCall")
UNION SELECT OfficeLocation,[Standby
Status],LastName,FirstName, 'Special Instructions'
FROM [Northwest Employees]
WHERE [Standby Status] In ("Service Standby", "Supervisor
OnCall");


Thank YOu