How to select if a given data exists in multiple tables and then update to table with result (only one table brings result)

Question

Somethings like:

UPDATE Table(Customers or Customers2) SET City ="A"
FROM (
SELECT City FROM Customers where id=1
UNION
SELECT City FROM Customers2 where id=1)

Somethings like: UPDATE Table(Customers or Customers2) SET City ="A" FROM ( SELECT City FROM Customers where id=1 UNION SELECT City FROM Customers2 where id=1) — Sergio Langa, Jul 29 '19 at 18:41
I recommend that you read this article and try posting your question again. https://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/ — Tab Alleman, Jul 29 '19 at 18:42
You need to run this with 2 different update statements. `UPDATE t SET City = 'A' FROM table1 AS t WHERE id = 1` and then `UPDATE t SET City = 'A' FROM table2 AS t WHERE id = 1` — JoeFletch, Jul 29 '19 at 18:46

score 0 · Answer 1 · answered Jul 29 '19 at 19:07

0

SQL Server can only update one table at a time in a given UPDATE statement. You need to use two updates:

UPDATE Customers 
    SET City = 'A'
    WHERE id = 1;

UPDATE Customers2 
    SET City = 'A'
    WHERE id = 1;

answered Jul 29 '19 at 19:07

Gordon Linoff

1 Answers1