SQL statement question

[cilu]

OK. My mistake. That works, but actually I want something else. I'm sorry for posting the wrong thing.

Here is what I actually want (this is much more complicated):

TABLE1:
ID   Name
1    aaa
2    bbb
3    ccc

TABLE2
ID   Name
1    pro1
2    pro2
3    pro3

TABLE3
ID   ID_TABLE1   ID_TABLE2
1    1                   1
2    1                   2
3    1                   3
4    2                   1

Can I do something like this:

aaa        pro1,pro2,pro3
bbb        pro1

This one means a string "pro1,pro2,pro3", but there can be another delimiter than ','.