Usefull and funny resources for SQL
Use delete with join
http://www.sqlservercentral.com/Forums/Topic493913-338-1.aspx
DELETE px
FROM #prodextend px
INNER JOIN #product p ON p.din = px.din
AND p.pkgSize = px.pkgSize
INNER JOIN #manu_clients mc ON mc.clientCode = p.clientCode
How to use in join in Update command
http://www.bennadel.com/blog/938-Using-A-SQL-JOIN-In-A-SQL-UPDATE-Statement-Thanks-John-Eric-.htm
UPDATE
b
SET
b.is_stud = 1
FROM
@boy b
INNER JOIN
@relationship r
ON
b.id = r.boy_id
INNER JOIN
@girl g
ON
(
r.girl_id = g.id
AND
g.name = 'Winona Ryder'
);
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=100415
224e8aa1-0d3b-4eb0-be22-5e7e1e794e07|0|.0