Something like this should work in MySQL, assuming datefield doesn't
duplicate within table2 for a given t1key.
select
t1.a, t1.b, t1.c, t2.datefield
from
table1 t1 left outer join table2 t2 on t1.id = t2.t1key
where
((t2.datefield = (select max(t2a.datefield) from tabl
OK -
I need to join on a table that has multiple records. However, I want
only to join on the record with the latest date.
I need this to be an left outer join.
Thanks,
James Cicenia
___
Do not post admin requests to the list. They will be ignored.