<BR>I have two tables I wish to join.<BR><BR>T1 (Primary Table) & T2<BR><BR>I wish to join T1 w/ T2 using left join where T1.F1 = T2.F1 AND T1.F2 = T2.F2. The trick is that in many cases, T2.F2 is a null field. When this is the case, I wish to join on the first criteria and to disregard the second criteria. <BR><BR>SELECT T1.F1, T1.F2, T1.F3, T1.F4, T2.F1, T2,F2<BR>FROM T1 LEFT JOIN T2 ON (T1.F1 = T2.F1) AND (T1.F2 = T2.F2)****EXCEPT WHERE T2.F2 IS NULL, THEN ****;<BR>FROM T1 LEFT JOIN T2 ON (T1.F1 = T2.F1)<BR><BR>I'm not sure if this is clear....!!