select from two tables

[Urbiasz]

Hello
I have 2 tables
Tabela1
id1 nazwa1
1 a
2 b
3 c
4 d

tabela2
id2 indeks2 nazwa2
1 1 test1
2 1 test2
3 2 test3
4 3 test4

and now, when I send ask to the serwer:

select id1,nazwa1,nazw a2 from tabela1 left outer join tabela2 on
tabela1.id1=tab ela2.indeks2

i have this answer:

id1 nazwa1 nazwa2
1 a test1
1 a test2
2 b test3
3 c test4
4 d

but I need this:

id1 nazwa1 nazwa2
1 a test1+test2
2 b test3
3 c test4
4 d

How to do it ?

[Plamen Ratchev]

Re: select from two tables

Here are a few methods by Anith Sen:

http://www.projectdmx.com/tsql/rowconcatenate.aspx

HTH,

Plamen Ratchev

http://www.SQLStudio.com