Question about INNER/OUTER join ??

[ZABADAK]

In the below query I need to do the first 2 SET statements even if the inner join finds no match in tblPriority, is this possible?


UPDATE tblSSRData As D INNER JOIN tblPriority As P ON D.TASK_PRI_CD_1 = P.Code
SET D.CLOSDATE = ED(PRO_FROM,CLS_FROM),
D.COMPDATE = ED(PRO_FROM,CLS_FROM,CAN_FROM), D.PRITARG = P.Target
WHERE (((D.REPORT_FROM_DATE)=#1/1/2005#) AND ((D.REPORT_THRU_DATE)=#1/31/2005#));

 

[Remou]

Hi
I think you would need to use a Left Join.