Thanks a lot that is the solution El Mié 16 Jul 2003 12:24, Egor Egorov escribió: > Patricio Gigoux <[EMAIL PROTECTED]> wrote: > > Hello: > > I have 2 tables > > t1: > > id age > > 1 7 > > 2 6 > > 3 7 > > 4 8 > > 5 9 > > 6 4 > > > > t2: > > age > > 7 > > 9 > > > > then I like select all in t1 without are in t2, so I need a result as > > follow id age > > 2 6 > > 4 8 > > 6 4 > > SELECT t1.* FROM t1 LEFT JOIN t2 ON t1.age=t2.age WHERE t2.age IS NULL;
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
