I have 2 table
both have identical columns but data is missing from tblDDAI that is in tblCards.
I have identified the records and now want to run an update query.
I am trying below
set tblDDAI.Photo = tblcards.Photo
where tblcards.ddaiid = '15'
I am getting an error
Error Code: 1054. Unknown column 'tblcards.ddaiid' in 'where clause'
The table is there with the correct column name