subject:"Left outer join combined with inner join"

Re: Left outer join combined with inner join

2004-06-01 Thread SGreen

06/01/2004 04:33 Subject: Left outer join combined with inner join

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

Left outer join combined with inner join

2004-06-01 Thread Matthew Shalorne

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 and in the tag column t