I'm trying to write an update query.
I want to read values from one table and insert those values in the second table.
I tried this
Code:
update 
klassement, deelnemerklasselevel 
SET 
klassement.LevelId = deelnemerklasselevel.levelId
where klassement.deelnemerId = deelnemerklasselevel.deelnemerId 
AND 
klassement.KlasseId = deelnemerklasselevel.KlasseId;
I get message 'Unknown column klassement.klasseId in where clause'

Can't figure it out.. you ?