SELECT Cases.ID, Employees.FirstName + ' ' + Employees.LastName, Customers.FirstName + ' ' + Customers.LastName FROM Cases LEFT OUTER JOIN Employees ON Cases.AssignedTo = Employees.ID LEFT OUTER JOIN Customers ON Cases.Customer = Customers.ID
And I continue to receive the following error:
LEFT OUTER JOIN Customers ON Cases.Customer = Customers.ID"
I really don't see where's my mistake.
This post has been edited by Keylogger: 27 April 2013 - 04:22 AM