problems with Update query with sub-select
Posted on 2004-03-25
I have two tables, Table1 and Table2 of the following structure:
PersonNumber - Primary key
RecordID is a numeric text field. In Table1 all RecordID are blanks. Table1 and Table2 are related by Table2.Email and Table1.EmailAddress fields. What I want is to transfer RecordID from Table2 to Table1.
I have the following sql statement:
UPDATE Table1 INNER JOIN Table2
SET Table1.RecordID=(SELECT Table2.RecordID FROM Table2)
But when I try to run this query I get an error "Operation must use an updateable query"
I'm using ms access