Posted By

wolfie on 02/21/08

Tagged

sql
update

Versions (?)

Last Edited at 02/21/08 11:56am

Statistics

Viewed 770 times

Favorited by 4 user(s)

Related snippets

Update from select

/ Published in: SQL

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

TO just SET TO a predetermined VALUE (TRUE, FALSE, 1, 'foo', etc.)
 
UPDATE tblDestination
SET tblDestination.col=VALUE
WHERE EXISTS (
SELECT col2.value
FROM tblSource
WHERE tblSource.join_col=tblDestination.join_col
AND tblSource.constraint=VALUE
)
 
More advanced (sets VALUE TO VALUE IN secondary SELECT statement):
 
UPDATE tblDestination
SET tblDestination.col=(SELECT col2.value FROM tblSource WHERE tblSource.join_col=tblDestination.join_col AND tblSource.constraint=VALUE)
WHERE EXISTS (
SELECT col2.value
FROM tblSource
WHERE tblSource.join_col=tblDestination.join_col
AND tblSource.constraint=VALUE
)