How arrange this join ??
From: mscertified (rupert_at_tigerlily.com)
Date: 03/25/05
- Next message: MGFoster: "Re: How arrange this join ??"
- Previous message: MGFoster: "Re: Max of the Max"
- Next in thread: MGFoster: "Re: How arrange this join ??"
- Reply: MGFoster: "Re: How arrange this join ??"
- Messages sorted by: [ date ] [ thread ]
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#));
- Next message: MGFoster: "Re: How arrange this join ??"
- Previous message: MGFoster: "Re: Max of the Max"
- Next in thread: MGFoster: "Re: How arrange this join ??"
- Reply: MGFoster: "Re: How arrange this join ??"
- Messages sorted by: [ date ] [ thread ]