accountsreport

SELECT account.mgm_id,

    account.organization,

    account.account_id,

    account.username,

    account.last_name,

    account.first_name,

    account."position",

    account.email,

    string_agg((accountgroup.account_group_type_name)::text, ';'::text) AS roles,

    account.creation_time,

    account.last_login_time,

    account.status,

    account.md5_encryption,

    account.synced_date

   FROM (account

     LEFT JOIN accountgroup ON (((account.mgm_id = accountgroup.mgm_id) AND (account.account_id = accountgroup.account_id))))

  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

  ORDER BY account.mgm_id, account.organization, account.account_id;