Update Table Query

F

Funky

am trying to update a table in Access using an SQL statement. I have 2 tables CarsTable and ABColour
CarsTabl
CRegno P
Mak
Mode
CColour F

ABColour
Reg_no P
Colou

I have used
UPDATE CarsTable INNER JOIN ABColours ON CarsTable.CregNo=ABColours.Reg_no SET CarsTables.CColour = ABColours.colour

Where am I going wrong

Thank
 
A

anthony

I think it has to do with the fact that CColours is a FK and Colour is not PK in its own table.
 
Top