nishantcm

A frnd helped me with this. Heres the query SELECT DISTINCT t1.set FROM table t LEFT JOIN table t1 ON t.item = t1.item WHERE t.set = 'A' AND t1.set <> 'A'

Hi. I am using php with mysql. I have a table cardtags. There are two columns- cardtagid and tagid. Plz see the attached image. The page for tag A will contain 1,2,7,8,10,11 I want to display links to tags B and C in page for tag A. Here link for tag D will not be displayed because none of the items are overlapping. Similarly, page for tag C will contain links to tags A, B, and D. So I want a query that will give me A,B,D as result when I have tag C as a parameter. I think this can be done with joins. Can anyone help me with this? Thanks. Nishant [attachment deleted by admin]