Link to home
Start Free TrialLog in
Avatar of jsctechy
jsctechyFlag for United States of America

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])=[APPOPTION].[ACCT_BETA]));
ASKER CERTIFIED SOLUTION
Avatar of appari
appari
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial