Update Table Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
I think it has to do with the fact that CColours is a FK and Colour is not PK in its own table.
 
Back
Top