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!
Microsoft AccessSQL

Avatar of undefined
Last Comment
terpsichore

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Terry Woods

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
terpsichore

this is basically working - I need to tweak some of the underlying query logic, but it works. thanks!
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck