Murray Brown
asked on
Join 4 Access SQL queries
Hi
I have 4 very similar Access SQL queries that I need to join on the fields MO, AO, AO2, AO3.
The queries look as follows:
SELECT Performance.Date, Performance.[Machine operator] AS MO, People.Phone
FROM Performance LEFT JOIN People ON Performance.[Machine operator] = People.[Operator COY];
SELECT Performance.Date, Performance.[Assistant operator] AS AO, People.Phone
FROM Performance LEFT JOIN People ON Performance.[Assistant operator] = People.[Operator COY];
SELECT Performance.Date, Performance.[Assistant operator 2] AS AO2, People.Phone
FROM Performance LEFT JOIN People ON Performance.[Assistant operator 2] = People.[Operator COY];
SELECT Performance.Date, Performance.[Assistant operator 3] AS AO3, People.Phone
FROM Performance LEFT JOIN People ON Performance.[Assistant operator 3] = People.[Operator COY];
I have 4 very similar Access SQL queries that I need to join on the fields MO, AO, AO2, AO3.
The queries look as follows:
SELECT Performance.Date, Performance.[Machine operator] AS MO, People.Phone
FROM Performance LEFT JOIN People ON Performance.[Machine operator] = People.[Operator COY];
SELECT Performance.Date, Performance.[Assistant operator] AS AO, People.Phone
FROM Performance LEFT JOIN People ON Performance.[Assistant operator] = People.[Operator COY];
SELECT Performance.Date, Performance.[Assistant operator 2] AS AO2, People.Phone
FROM Performance LEFT JOIN People ON Performance.[Assistant operator 2] = People.[Operator COY];
SELECT Performance.Date, Performance.[Assistant operator 3] AS AO3, People.Phone
FROM Performance LEFT JOIN People ON Performance.[Assistant operator 3] = People.[Operator COY];
ASKER
Hi
I'd like
Date, Operator, Phone
Thanks
I'd like
Date, Operator, Phone
Thanks
ASKER
Actually would like to try both but can post a further question to get the latter.
Thanks very much for the help
Thanks very much for the help
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Excellent. Thank you very much!
Date, MO, AO, AO2, AO3, PhoneMO, PhoneAO, PhoneAO2, PhoneAO3?
Or
Date, Operator, Phone?