> select * from table1 t1 left join table2 t2 on t1.date1=t2.date2 where > t2.date2 is null > where t2.name='Smith'
Maybe this? select * from table1 t1 left join table2 t2 on t1.date1 = t2.date2 AND t2.name = 'Smith' WHERE t2.date2 is null; -- Scott Noyes [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
