Skip to content

Instantly share code, notes, and snippets.

@ksakae1216

ksakae1216/sql2

Created March 3, 2017 14:22
Show Gist options
  • Save ksakae1216/e13aa060c1a1d929b89d0f965da7fef5 to your computer and use it in GitHub Desktop.
Save ksakae1216/e13aa060c1a1d929b89d0f965da7fef5 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
sql2
SELECT
m1.id, m1.name
,m2.id, m2.name
,m3.id, m3.name
FROM
transaction
,master m1
,master m2
,master m3
WHERE
transaction.id1 = m1.id
AND
transaction.id2 = m2.id
AND
transaction.id3 = m3.id
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment