get users from agent id

Please login or create account to add a snippet.

Follow @TagMyCode

Language: SQL

Posted by: Philip Imperato

Added: Jun 4, 2018 4:58 PM

Tags: no tags

SELECT * FROM "Users" AS "Users"
LEFT OUTER JOIN "Roles" AS "Role" ON "Users"."roleId" = "Role"."roleId"
INNER JOIN ("Agency_XRef" AS "Agencies.Agency_XRef" INNER JOIN "Agencies" AS "Agencies" ON "Agencies"."agencyId" = "Agencies.Agency_XRef"."agencyId") ON "Users"."userId" = "Agencies.Agency_XRef"."userId"
AND "Agencies"."agencyId" IN (23)
WHERE "Users"."roleId" IN (3, 4, 5, 6, 7, 8) AND "Users"."archived" = FALSE
ORDER BY "Users"."email" ASC