Re: Left outer join combined with inner join

2004-06-01 Thread SGreen
Hi Matthew, There are several combination of things you can query for with the data you have: Only Products with Tags, Only Tags with products, all Products with or without Tags, all Tags with or without Products However you do not have the ability (yet) to query, in a single statement, for

Re: Left outer join combined with inner join

2004-06-01 Thread gerald_clark
Matthew Shalorne wrote: Hi, with the tables eg: Product: id, product, cost ProductTag: productId, TagId Tag: id, tag I have created the ability to selectively assign tags to products if required via a many-to-many relationship. Now I want to join the tables in MySQL so that I can see all products