There are 2 tables in an application system.

The first table "grpmem" contains both group_id and member fields.

select id, c_last_name from ctct where id = 735169
id                    c_last_name
735169            Property Service Officer

In the second table "ctct", it contains both data for Role and Member (First
Name and Last Name).

select id, c_last_name from ctct where id = 735169
id                    c_last_name
735169            Property Service Officer

I have created 2 queries so that the first one retrieve the Group Name while
the second one retrieve the Member Name.   Then I export it to an Access
Database and perform a LEFT JOIN (There are more Groups than Members).

The result I would like to get is as follow (This is because the Role
returned is more than the rows of Name)
780205            Property Service Officer      James       Pang
780256            Property Service Supervisor
780257            Property Service Manager      Gary        Poon

I just wonder whether it can be achieved by running a SQL Script by using
LEFT JOIN ?

Thanks
Patrick