Dear All,
i am using MS Access 2007
My Sql Query is :
Code:
UPDATE EmailSetup SET Email1 = (select Email1 from BranchEmails where EmailSetup.BranchCode=BranchEmails.BranchCode), Email2 = (select DISTINCT Email2 from BranchEmails where EmailSetup.BranchCode=BranchEmails.BranchCode);
and the error is :
"Operation must use an updateable query"
please advise
query should be applied like this :
Code:
UPDATE EmailSetup as B INNER JOIN BranchEmails as A ON B.BranchCode = A.BranchCode SET B.Email1 = [A].[Email1] ,B.Email2 = [A].[Email2] WHERE B.BranchCode = A.BranchCode
Regards