Hello all,
I'm running into the following error while trying to run a query.. Can anyone shed some light on it? I've read that the error is typically related to needing ()'s somewhere around the join, but I cant make sense of it..
tblTest:
strProdCode - Text
dtmFrom - Date/Time
tblProduct
strProdCode - Text
dtmFrom - Date/Time
The Error:
syntax error (missing operator) in query expression 'tblTest.dtmFrom FROM tblTest INNER JOIN tblProduct ON tblTest.strProdCode = tblProduct.strProdCode'
The Query:
UPDATE tblProduct
SET tblProduct.dtmFrom = tblTest.dtmFrom
FROM tblTest INNER JOIN tblProduct ON tblTest.strProdCode = tblProduct.strProdCode
WHERE
tblProduct.dtmFrom IS NULL;
The Goal:
Update tblProduct.dtmFrom if it is NULL and set it to tblTest.dtmFrom where the strProdCode is the same in both. I have a bunch of strProdCodes with null values currently, and I am trying to replace them, but only if they are null.
Thanks,
DAN
Bookmarks