I have two tables that are related.
In one table, there's a list of tags and products they're associated with. (Row 1 = Tag, Row 2 = Product ID)
In the second table, there's the list of products the actual products. (Row 1 = Product ID, Row(s) 2-X other product info)
I know that getting the two together requires a join of some sort.
How would you go phrasing the SQL query to
(From Table 1)
"Select * from TAG where TAG = "x"
(and then display (from table 2))
All product IDs identified from Table 1