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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update a table from a query 7
Linked SQL Tables don't report Cascading Updates and Deletes 2
Calculation in Update query drops decimal places 2
Update query using 2 tables 2
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Operation must use an Updatable Query 2
delete query - could not delete from specified table 4
Delete query - delete from specified tables error 4

Back
Top