Lincoln Milner said: > Or, if I'm not mistaken, you could do something like: > SELECT t1.* > FROM table1 t1, table2 t2 > WHERE t1.id = t2.rdid > AND t2.vid IN (46, 554) > ; > > That should work
No. You are back to square one where there should only be one record in t2 with a vid of either 46 or 554. What is requested is a solution where there are 2 records in t2, one with a vid of 46 and one with a vid of 554. > I can never get > the joining straight, so I always enjoy a shorter route. Just make sure the shorter route gives the same results. Jochem -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]