At 04:33 PM 11/8/2005, Scott Noyes wrote:
> 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]
Scott,
I had actually tried something like that before, with the same
results (no results returned). It turns out I had left something else in
the Where clause that created another paradox. So I took it out of the
Where clause and put it into the join and it works! Thanks :)
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]