UPDATE with a subquery

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

Guest

I have a Control table with two columns: File and Job. Job is the KEY and
File has the value I want to update another table with.

I want this query to work:
UPDATE tbl_MA_Ext SET File = (SELECT File
FROM tbl_Control
WHERE Job = "9A");

The error I receive is:
"Operation must use an updateable query."

It is guarenteed that only one value will be returned by the SELECT.
 
Robin,

One way would be...
UPDATE tbl_MA_Ext SET File = DLookup("[File]","tbl_Control","[Job]='9A'")
 
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 with subquery answer 1
SQL Syntax for an update query 2
Can a Table be Updated From a Subquery with Aggregate Count Value? 6
Subquery nested in Update query 1
update subquery 1
Crosstab query as data source for update query 7
Query and subquery 2
I Need a subquery to replace Dlookup 7

Back
Top