Skip to content

Instantly share code, notes, and snippets.

@franc3000

franc3000/update_inner_join.sql

Created November 3, 2017 19:40
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save franc3000/1d3341d8cd6022623ee54400f2bbd4bd to your computer and use it in GitHub Desktop.
Save franc3000/1d3341d8cd6022623ee54400f2bbd4bd to your computer and use it in GitHub Desktop.
Download ZIP
update inner join
Raw
update_inner_join.sql
update tableA a
inner join tableB b
on a.RTPropertyUniqueIdentifier=b.RTPropertyUniqueIdentifier
SET a.fips=b.SitusStateCountyFIPS,
a.col2=b.col2;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment