29 September 2008

SQL Update

Try as i might, i NEVER remember how to do this:

UPDATE table1
SET snakesOnAPlane = t2.data
FROM table1 t1
JOIN table2 t2 ON t2.row1 = t1.row1
WHERE t1.row3 = 'helloWorld'

No comments: