Posted on 2009-12-18
I have a table, tblsuggestedproducts, that has productid, suggestedproductid. Both of these fields relate to the primary key, productid, in tblproducts
tblsuggestedproducts looks like this
I want to return a query that gives me the related data in tblproducts for both the tblsuggestedproducts.productid and the tblsuggestedproducts.suggestedproductid....any help would be appreciated.