Sometimes, solutions are easier than thought, and I believe this is the case.
There are some questions where the answer is no and that is totally fine.
Tweet Sometimes, when searching for an answer, we end up making things too much complicated, while easy solutions are just round the corner.
This is the case of a simple task like updating two related tables with just one SQL query. The first contains user names, and the second email addresses related to the first table names.
UPDATE summary_data SET current_category = (SELECT category_id FROM products WHERE products.product_id = summary_data.product_id) WHERE EXISTS (SELECT category_id FROM products WHERE products.product_id = summary_data.product_id); If you want to test your skills using the SQL UPDATE statement, try some of our practice exercises.
These exercises allow you to try out your skills with the UPDATE statement.
WAprrs = 'start,stop' FROM Table1 T1, Table2 T2 WHERE T1= T2and T1= '011008'; COMMIT; @unknown: Based on your comment, you would need to join across both Table1 and Table2 when you update Table2 if your update query needs the keys from a third table.Should any right be infringed, it is totally unintentional.Drop me an email and I will promptly and gladly rectify it.In this article, we are going to look at four scenarios for Oracle cross table update. Category_ID) where exists ( select * from Categories b where b. These columns uniquely identify a record in a table.Suppose we have two tables Categories and Categories_Test. The common column in the two tables is CATEGORY_ID. Please note that query below is used for illustration purpose because Category_ID alone is primary key.