Problem with Query Access/SQL 1

[VonFranzken]

I am using an access database, and when I run my query I get the following error but cannot figure out where the snytax error is.

[Microsoft][ODBC Microsoft Access Driver]Syntax error (missing operator) in query expression dbrderDetails.DetailOrderID = dbrders.OrderReferenceID INNER JOIN dbo.Users ON dbrders.OrderUserID = dbo.Users.UserID

Here is my SQL statement:

SELECT dbrders.OrderReferenceID, dbrders.OrderTotal, dbrders.OrderDate, dbo.Users.FullName, dbrderDetails.DetailQuantity
FROM dbrderDetails INNER JOIN
dbrders ON dbrderDetails.DetailOrderID = dbrders.OrderReferenceID INNER JOIN
dbo.Users ON dbrders.OrderUserID = dbo.Users.UserID

 

[r937]

access requires its joins to be parenthesized

SELECT dbo.Orders.OrderReferenceID
     , dbo.Orders.OrderTotal
     , dbo.Orders.OrderDate
     , dbo.Users.FullName
     , dbo.OrderDetails.DetailQuantity
  FROM [COLOR=red]([/color]
       dbo.OrderDetails 
INNER 
  JOIN dbo.Orders 
    ON dbo.OrderDetails.DetailOrderID 
     = dbo.Orders.OrderReferenceID 
       [COLOR=red])[/color]
INNER 
  JOIN dbo.Users 
    ON dbo.Orders.OrderUserID 
     = dbo.Users.UserID

r937.com | rudy.ca

 

[VonFranzken]

Thanks for helping me with this.

I tried your statement and got syntax error in join operation.

fyi.

STeve

 

[r937]

yeah, well, you did you were using access, didn't you

however, those are not valid access table names

are you using linked tables to sql server?



r937.com | rudy.ca

 

[VonFranzken]

The table names in access are Orders, OrderDetails, Users in access..

Thanks.
Steve

 

[r937]

so does it work when you change the table names?

r937.com | rudy.ca

 

[VonFranzken]

The table names in your statement look correct.

 

[r937]

okay, great

r937.com | rudy.ca