Updating two tables in a single query in sql allison janney dating
I came across this error when I was trying to update data in a local Access table by using the matching data in a linked table in Oracle.
Now here is the real reason for this blog post – yesterday I was asked this question again and I replied my canned answer saying it is not possible and it should not be any way implemented that day. I think you may want to understand the concept of the foreign keys and cascading update/delete.The three queries below produce the same result, but none of them succeeded due to the Access error "Operation must use an updatable query". update Customer Sales_Retail as a inner join ( select Customer ID, Sales Date from Customer Sales where Customer ID in (select distinct Customer ID from Customer Sales_Retail) ) as b on a. Step #1: Make-Table query - create an intermediate (temporary but physical) local table To sum up, when we do multiple table updates in MS Access, first we need to make sure that the source table contains unique data in the joined column(s).Query 1: This is the most common way to do multiple table update in Access. This may be a primary key column or a column with unique index, or columns with combined uniqueness (also known as composite unique index).Here are the 3 update queries I tried and got the same error each time.Customer Sales is a linked table (the source table - data came from this table).