Skip to content

Instantly share code, notes, and snippets.

@arman-hpp
Created October 28, 2015 07:22
Show Gist options
  • Save arman-hpp/898438a990cf54071444 to your computer and use it in GitHub Desktop.
Save arman-hpp/898438a990cf54071444 to your computer and use it in GitHub Desktop.
SELECT * FROM TempOrgan
LEFT OUTER JOIN TOrgan ON TempOrgan.Organ Like '%' + TOrgan.OrganName + '%'
WHERE TOrgan.OrganName IS NULL
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment