How arrange this join ??

From: mscertified (rupert_at_tigerlily.com)
Date: 03/25/05


Date: Fri, 25 Mar 2005 13:35:03 -0800

In the below query I need to do the first 2 SET statements even if the inner
join finds no match n 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#));