1
SELECT systemgroupmember.mgm_id,
2
systemgroupmember.system_group_id AS group_id,
3
systemgroupmember.group_name,
4
system.system_id,
5
system.profile_name AS system_name,
6
systemgroupmember.synced_date
7
FROM (systemgroupmember
8
JOIN system ON (((systemgroupmember.mgm_id = system.mgm_id) AND (systemgroupmember.system_id = system.system_id))))
9
ORDER BY systemgroupmember.mgm_id, systemgroupmember.system_group_id, systemgroupmember.system_id;