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
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