Link to home
Start Free TrialLog in
Avatar of 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!
Avatar of Terry Woods
Terry Woods
Flag of New Zealand image

Link to home
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


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