systemgroupssystemsreport

SELECT systemgroupmember.mgm_id,

    systemgroupmember.system_group_id AS group_id,

    systemgroupmember.group_name,

    system.system_id,

    system.profile_name AS system_name,

    systemgroupmember.synced_date

   FROM (systemgroupmember

     JOIN system ON (((systemgroupmember.mgm_id = system.mgm_id) AND (systemgroupmember.system_id = system.system_id))))

  ORDER BY systemgroupmember.mgm_id, systemgroupmember.system_group_id, systemgroupmember.system_id;