Skip to content

Instantly share code, notes, and snippets.

@byeblogs

byeblogs/Join Multiples Table

Last active May 25, 2021 11:41
Show Gist options
  • Save byeblogs/44f619c9939feafdecfb to your computer and use it in GitHub Desktop.
Save byeblogs/44f619c9939feafdecfb to your computer and use it in GitHub Desktop.
Download ZIP
Join Multiple Tablet MySQL
Raw
Join Multiples Table
SELECT DI.HB_NAME, D.DESTINATION_CODE, CI.COUNTRY_CODE
FROM DESTINATION_ID as DI
JOIN DESTINATION as D
ON D.DESTINATION_CODE = DI.DESTINATION_CODE
JOIN COUNTRY_ID as CI
ON CI.COUNTRY_CODE = D.COUNTRY_CODE
WHERE (CI.COUNTRY_CODE = 'ID')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment