Table 1 Table 2 ___________ _____________ ID rdid vid ___________ _____________
ID in table 1 links to rdid in table 2. This is a one to many relationship. Now I wish to find all the items in table 1 where table2.rdid= table1.rdid and (table2.vid=46) and (table2.vid=554)
In other words which records from table 1 link to two records in table 2 who's vid are 46 and 554.
I hope this makes sense.
Thanks Joe
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
