Link to home
Start Free TrialLog in
Avatar of terpsichore
terpsichore

asked on

simple subquery question

Dear experts -
I have a query that is unupdatable. It has a key field called "ID".
I want to run an update query that updates a tabled called Vendor_Invoices (which has the same ID field) for any ID that is found in the unupdatable query.

Doing a simple inner join update query is not working (it's saying the query is not updatable). I'm suspecting I need a subquery.

This is the code that is giving me the unupdatable message:
UPDATE Vendor_Invoice_ExporttoExcel INNER JOIN Vendor_Invoices ON Vendor_Invoice_ExporttoExcel.ID = Vendor_Invoices.ID SET Vendor_Invoices.ExportDate = Date();

Many thanks!
ASKER CERTIFIED SOLUTION
Avatar of Terry Woods
Terry Woods
Flag of New Zealand image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of terpsichore
terpsichore

ASKER

this is basically working - I need to tweak some of the underlying query logic, but it works. thanks!