Skip to content

Instantly share code, notes, and snippets.

@hugotai101

hugotai101/updatedatarelated.sql

Created May 6, 2021 08:15
Show Gist options
  • Save hugotai101/85a6dd861ece7253c9605297757131f5 to your computer and use it in GitHub Desktop.
Save hugotai101/85a6dd861ece7253c9605297757131f5 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
updatedatarelated.sql
select name, tk.[key], tk.roomname,*
from tbFacility
left join temproomkey tk on name like CONCAT('%', tk.roomname, '%')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment