jsctechy
asked on
how to rewrite this SQL statemen in SQL 2005
how can i rewrite this access query in SQl 2005?
UPDATE APPOPTION LEFT JOIN ConvertedAccts ON [APPOPTION].ACCT_BETA = ConvertedAccts.[PERACCT]
SET [APPOPTION].ACCT_BETA = [ConvertedAccts].[NFSACCT]
WHERE (((ConvertedAccts.[PERACCT ])=[APPOPT ION].[ACCT _BETA]));
UPDATE APPOPTION LEFT JOIN ConvertedAccts ON [APPOPTION].ACCT_BETA = ConvertedAccts.[PERACCT]
SET [APPOPTION].ACCT_BETA = [ConvertedAccts].[NFSACCT]
WHERE (((ConvertedAccts.[PERACCT
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.