multi-part identifier error?
Posted on 2015-01-29
I have 2 different tables in the same database.
The tables are similar:
where the userID and Date are the same UserID and Date from each table, with
SET tblGasInvoice.[ Volume] = tblTemp.Volume
WHERE tblTemp.UserID = tblInvoice.UserID AND
tblTemp.Date = tblInvoice.Date
I get the following error:
The multi-part identifier "tblTemp.UserID" could not be bound.
The multi-part identifier "tblTemp.Date" could not be bound.
I wrote out the code using intellisense in SMS to make sure there were no typos in the naming
Thanks for your help!