3 Replies - 5787 Views - Last Post: 27 April 2013 - 05:11 AM

#1 Keylogger  Icon User is offline

  • D.I.C Regular

Reputation: 7
  • View blog
  • Posts: 344
  • Joined: 14-February 11

[Solved] Problem with 2 Left Outer Join

Posted 27 April 2013 - 04:13 AM

Hi, I have the following:
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:

Quote

Syntax Error (missing operator) in query expression 'Cases.AssignedTo = Employees.ID
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


Is This A Good Question/Topic? 0
  • +

Replies To: [Solved] Problem with 2 Left Outer Join

#2 Keylogger  Icon User is offline

  • D.I.C Regular

Reputation: 7
  • View blog
  • Posts: 344
  • Joined: 14-February 11

Re: [Solved] Problem with 2 Left Outer Join

Posted 27 April 2013 - 04:22 AM

Just solved it..stupid mistake by Access.
Resolution: http://nm1m.blogspot...-ms-access.html
Was This Post Helpful? 0
  • +
  • -

#3 andrewsw  Icon User is offline

  • Fire giant boob nipple gun!
  • member icon

Reputation: 3480
  • View blog
  • Posts: 11,867
  • Joined: 12-December 12

Re: [Solved] Problem with 2 Left Outer Join

Posted 27 April 2013 - 04:24 AM

You need brackets with Access, as demonstrated on this page (found after a very brief Google :)).

Please post your corrected sql as it may prove useful to others.
Was This Post Helpful? 0
  • +
  • -

#4 Keylogger  Icon User is offline

  • D.I.C Regular

Reputation: 7
  • View blog
  • Posts: 344
  • Joined: 14-February 11

Re: [Solved] Problem with 2 Left Outer Join

Posted 27 April 2013 - 05:11 AM

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


Was This Post Helpful? 0
  • +
  • -

Page 1 of 1