hi,

please help me out....


I have 2 table, Say T1 and T2
Above 2 table have a datatime field in it.
I want to left join this two table such that
if(T1.datatime field > T2.datatime field)
i want to populate the join records with the fields from T2
else
i want to populate the join records with fields from T2 as Null



please...