Solved: Trouble connecting tables

[austenr]

Can someone please show me how to connect the tables in this test DB attachment correctly? Thanks.

[austenr]

in case you dont want to open the attachment, here are the tables:

Item

itemID Auto increment
ItemName
description
categoryID

Category

categoryID Auto increment
CategoryName

ItemOrderMembership

orderID
itemID

My question is how to connect the orderID to the Category and Item tables. Would you use a left join on itemID from the Item table to join the itemID in the ItemOrderMembership table?

[mohanvijay]

SELECT * FROM Item t0 INNER JOIN Category t1 ON t0.categoryID=t1.categoryID INNER JOIN ItemOrderMembership t2 on t0.itemID=t2.itemID

[austenr]

thanks that got it.