Function needed

I've seen similar queries to this one posted here but don't remember seeing this one, and Google doesn't help...

Dumb example follows.

Here's the first table:

Field1 Field2
------ ------

1        A
1        C
1        B
1        D
2        E
2        F
2        G

Here's the second table:

Field2 Field2_Name
------ -----------

A        A's Name
B        B's Name
C        C's Name
D        D's Name
E        E's Name
F        F's Name
G        G's Name

I need a function on Field2 that will return:

Field2 Return value
------ ------------

A        B's Name, C's Name, D's Name
B        A's Name, C's Name, D's Name
C        A's Name, B's Name, D's Name
D        A's Name, B's Name, C's Name
E        F's Name, G's Name
F        E's Name, G's Name
G        E's Name, F's Name