SQL error on update

  • Thread starter Thread starter Christopher Jon Jursa
  • Start date Start date
C

Christopher Jon Jursa

Hello,

I have the following SQL statement attempting to join data from two tables
and place the correct number from
the area (foreign) table in the contacts (primary) table.

There is a one to many relationship between the contacts.areaID and the
area.areaID table. The area table has a text field area.area that should
match contacts.area. I am trying to replace the contact.area field in the
contact table with the number field area.area.

UPDATE contacts
SET contacts.areaID =
(SELECT area.areaID
FROM contacts, area
WHERE contacts.area = area.area);

When I run the statement, I get a message saying "Operation must use an
updatable query". What does that mean?

Cheers,

Chris
 
Back
Top