Update / Delete with Joins

[Duane Phillips]

Asking for some sample SQL/SP code to perform updates/deletes with joined
tables.

Example 1:
For every record that is matched on both tables A and B, update a field in
table A.

Example 2:
For every record that is matched on both tables A and B, delete record in
table A.

TIA.

~ Duane Phillips.

[David Portas]

Example 1:

UPDATE table_a
SET col = ? /* Unspecified */
WHERE EXISTS
(SELECT *
FROM table_b
WHERE table_b.key_col = table_a.key_col)

Example 2:

DELETE FROM table_a
WHERE EXISTS
(SELECT *
FROM table_b
WHERE table_b.key_col = table_a.key_col)

--
David Portas
SQL Server MVP
--

[Duane Phillips]

Many Thanks!

~ Duane Phillips.

"David Portas" <RE****************************@acm.org> wrote in message
news:k9********************@giganews.com...

Example 1:

UPDATE table_a
SET col = ? /* Unspecified */
WHERE EXISTS
(SELECT *
FROM table_b
WHERE table_b.key_col = table_a.key_col)

Example 2:

DELETE FROM table_a
WHERE EXISTS
(SELECT *
FROM table_b
WHERE table_b.key_col = table_a.key_col)

--
David Portas
SQL Server MVP
--