Problem with Join 1

[VonFranzken]

What am I missing here?

SELECT OrderID, DetailOrderID, OrderUserID, DetailProductName, DetailQuantity, DetailPrice, OrderShipping, OrderTotal, OrderDate, Firstname
FROM Orders AS o, OrderDetails AS d, Users AS u
where rderID = d.DetailOrderID
and rderUserID = u.UserID

 

[DotNetGnat]

what is the error that you are getting...

-DNG

 

[VonFranzken]

I dont get an error but when I switch to preview the query it doesnt display any data and there are records and relationships.

Steve

 

[DotNetGnat]

is it because Users and UserId are keywords??

not sure though...try to wrap them in square braces...something like [UserId]

-DNG

 

[JerryKlmns]

I would use rderID ...

but have to guess in which table belongs the fields below, so add them accordingly

SELECT OrderID, DetailOrderID, OrderUserID, DetailProductName, DetailQuantity, DetailPrice, OrderShipping, OrderTotal, OrderDate, Firstname
FROM (Orders AS o Inner Join OrderDetails AS d On rderID = d.DetailOrderID) Inner Join [Users] AS u On
rderUserID = u.UserID

 

[VonFranzken]

You guessed right Jerry, and now shows the top row of the query but no data? Under OrderID it says AutoNumber???

Hmmm.

Thanks for your help with this.

 

[JerryKlmns]

Change from SQL view to Design View and play with the grid. I hope the join is Ok.