Tuesday, April 22, 2014

an UPDATE with a JOIN in SQL!

UPDATE dbo.foo SET columnINSIDEfoo=13
FROM dbo.foo f
JOIN dbo.bar b ON b.barID = f.barID
WHERE b.columnINSIDEbar=42

No comments:

Post a Comment