I'm new..help me

[Anon]

hi
i'm newbie i want to know how i can do like this
i have 2 table

table one

| gid | data |
| 1 | A,B,C
| 2 | D,E

and table two

| gid | name |
| 1 | Duck |
| 2 | Cat |

how i want it to be like this

| name | data |
| Duck | A,B,C |
| Cat | D,E |

thank

[brandonschnell]

SELECT name, data FROM table1,table2 WHERE table1.gid = table2.gid;