Skip to content

Instantly share code, notes, and snippets.

@jetaggart
Created May 28, 2017 04:44
Show Gist options
  • Save jetaggart/a14c6c4e8ded1127e9c709dfe6190826 to your computer and use it in GitHub Desktop.
Save jetaggart/a14c6c4e8ded1127e9c709dfe6190826 to your computer and use it in GitHub Desktop.
SELECT "user_id2_2" as "result1_4",
"id0_1" as "result2_4",
"email1_1" as "result3_4",
"name1_3" as "result4_4"
FROM (SELECT *
FROM (SELECT "id" as "id0_1",
"email" as "email1_1"
FROM "user" as "T1") as "T1",
(SELECT "id" as "id0_2",
"organization_id" as "organization_id1_2",
"user_id" as "user_id2_2"
FROM "organization_user" as "T1") as "T2",
(SELECT "id" as "id0_3",
"name" as "name1_3",
"zip_code" as "zip_code2_3"
FROM "organization" as "T1") as "T3"
WHERE (("id0_3") = ("organization_id1_2")) AND (("id0_1") = ("user_id2_2"))) as "T1"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment