Experts, I need to know if the bold part below means that there would be a hit if the tblLetterOfCredit.LCNo is not IN import-jpm. Is that what it is saying or is it the other way around?
Do I need to have quotes around something because the LCNo is text?
I want to return hits that are not IN import-jpm. Meaning that if there is a LCNo in tblLetterOfCredit and there is no match on import-JPM then show that one. The BankID = 1 is not part of the issue.
SELECT tblLetterOfCredit.EndUserID, tblBanks_Participating.BankID, tblLetterOfCredit.LCNo, tblLetterOfCredit.Amount, tblLetterOfCredit.ExpiredYN, tblLetterOfCredit.CanceledDate, tblLetterOfCredit.DateOfIssueSB
FROM tblLetterOfCredit LEFT JOIN tblBanks_Participating ON tblLetterOfCredit.LetterOfCreditID = tblBanks_Participating.LCID
WHERE (((tblBanks_Participating.BankID)=1) AND ((tblLetterOfCredit.LCNo) Not In (select [JPM Ref Number] from [Import-JPM])));