Hi
Ive reached my own limit with this one... hopefully its not that tricky.
I have a products table, each with a unique id. I then have a complimentary_items table which links two products as 'matches'.
The complimentary items table has three columns: id, prod_id1, prod_id2. Can I write 1 query, which pulls out all of the matches as well as fetches the associated names from the product table?
lworks