Skip to content

Instantly share code, notes, and snippets.

@arsham

arsham/innerFiller.sql

Created May 17, 2013 15:50
Show Gist options
  • Save arsham/5599993 to your computer and use it in GitHub Desktop.
Save arsham/5599993 to your computer and use it in GitHub Desktop.
Download ZIP
Update a table, feeding a column from inner join of two other tables as reference
Raw
innerFiller.sql
UPDATE T1P
INNER JOIN T2
ON T1.match1 = T2.match1
INNER JOIN T3
ON T3.match2 = T2.match2
SET T1.new_column = T3.source_of_new_column;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment