This content has been marked as final. Show 4 replies
from customer c join customer_product cp on c.customer_id = cp.customer_id
join product p on p.product_id = cp.product_id
Dan's example is ok but you need to prefix the columns you select like the attached.
(Also you need left join for customers that haven't ordered anything yet)
Finally, if you are using MS access, let us know since the syntax is non standard for that.
Thanks for the replies gents.
As archaic as it is, this one does use Access...
Ok, the attached has the same example rewritten for Access' bogus syntax.
Try to write your queries using Access' query designer. You won't be able to read them but they will work.