Create a gist now

Instantly share code, notes, and snippets.

What would you like to do?
SELECT
master.name
,ko_master.city_name
,mago_master.kubun
FROM
master
LEFT OUTER JOIN ko_master
ON
master.id = ko_master.oya_id
LEFT OUTER JOIN mago_master
ON
master.name = mago_master.oya_name
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment