Urgent help needed! - Connect query

C

C

New at query writing. I have the following two tables that I need to search
for users that are defined to the same connects. Using the following sample
tables, the query would return:

Id Default Grp: Connects:
A1234 xyzs01tr xyzs01tr
D1234 term2day
xyz01tr

Sample data:

Ids main table

Id Name Default Grp:

A1234 xyzs01tr
B2345 xyzs01tr

C1234 xtra2
D1234 xterm2day
E1234 xtra2

Connects table

Id: Connects:

A1234 xyzs01tr
A1234 term2day
A1234 xyz01tr
B2345 xyzs01tr
B2345 term2day
C1234 xtra4now
C1234 xtra2
D1234 term2day
D1234 xyzs01tr
D1234 xyz01tr

Thanks in advance for any assistance provided.
 
Top