1
SELECT account.mgm_id,
2
account.organization,
3
account.account_id,
4
account.username,
5
account.last_name,
6
account.first_name,
7
account."position",
8
account.email,
9
string_agg((accountgroup.account_group_type_name)::text, ';'::text) AS roles,
10
account.creation_time,
11
account.last_login_time,
12
account.status,
13
account.md5_encryption,
14
account.synced_date
15
FROM (account
16
LEFT JOIN accountgroup ON (((account.mgm_id = accountgroup.mgm_id) AND (account.account_id = accountgroup.account_id))))
17
GROUP BY account.mgm_id, account.organization, account.account_id, account.username, account.last_name, account.first_name, account."position", account.email, account.creation_time, account.last_login_time, account.status, account.md5_encryption, account.synced_date
18
ORDER BY account.mgm_id, account.organization, account.account_id;