question on SELECT using LIKE

Please respond to ajay(at)crossbeamsys(dot)com since I don't subscribe to the
mailing list.

I have 2 tables :

Table1
Name Age
joe 23
mark 25
linda 22

Table2
NameList Group
joe group1
mark group2
joe linda group3

For each person in Table1, I want to list the groups that he/she is a member
of. Table2 has the group membership information, but notice that the first
column of Table2 is a list of names rather than a single name.

I want to be able to use the the following SELECT call :

SELECT t1.name, t2.group
FROM table1 t1, table2 t2
WHERE t2.namelist LIKE %t1.name%;

But its not working. The problem is in '%t1.name%', the second operand of
LIKE.

Thanks in advance. Please Cc your reply to ajay(at)crossbeamsys(dot)com as well.

Ajay