I have the below SQL.
I need to update blLetterOfCredit.[Guarante
eCode] to the value in Import-csm.[Guarantor Code]
I think I have it right but it gives me an error that basically says it cant update due to key violations.
Import-csm.[Guarantor Code] and tblLetterOfCredit.Guarante
eCode are both the same property in the tables as Double, General Number and Indexed No duplicates. I initially had Import-csm.[Guarantor Code] as a Primary Key thinking that might be the issue but I removed it and still have the same error.
What do you think could be the cause of this error?
here is the SQL:
UPDATE [Import-CSM] INNER JOIN tblLetterOfCredit ON [Import-CSM].[Reference Number] = tblLetterOfCredit.LCNo SET tblLetterOfCredit.Guarante
eCode = [Guarantor Code];