Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 364
  • Last Modified:

Syntax

Experts:  I get a syntax in the where condition.  I have played arond with it.   It highlights at the beginning of the Select.  thank you.

UPDATE [import-CSM2] INNER JOIN tblLetterOfCredit ON [import-CSM2].[Reference Number] = tblLetterOfCredit.LCNo SET [import-CSM2].LCID = [tblLetterOfCredit].[LetterOfCreditID]
WHERE ((([import-CSM2].[LCID]) Not In (SELECT [tblLetterOfCredit].[LCID] AND (([import-CSM2].[Actual Status])<>"GEC"));
0
pdvsa
Asked:
pdvsa
1 Solution
 
Rey Obrero (Capricorn1)Commented:
WHERE [import-CSM2].[LCID] Not In (SELECT [tblLetterOfCredit].[LCID] From [tblLetterOfCredit]) AND [import-CSM2].[Actual Status]<>"GEC";
0
 
pdvsaProject financeAuthor Commented:
thanks...
0
 
mbizupCommented:
Worth trying this variation as well - you might get better performance without the NOT IN/subquery:

UPDATE [import-CSM2] LEFT JOIN tblLetterOfCredit 
ON [import-CSM2].[Reference Number] = tblLetterOfCredit.LCNo 
AND [import-CSM2].[LCID] = [tblLetterOfCredit].[LCID] 
SET [import-CSM2].LCID = [tblLetterOfCredit].[LetterOfCreditID]
WHERE  [import-CSM2].[Actual Status])<>"GEC" AND  [tblLetterOfCredit].[LCID] IS NULL

Open in new window

0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now