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