Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Microsoft SQL Server > select from two...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 2 Topic 11084 of 11517
Post > Topic >>

select from two tables

by "Urbiasz" <admin@[EMAIL PROTECTED] > May 27, 2008 at 04:57 PM

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,nazwa2 from tabela1 left outer join tabela2 on 
tabela1.id1=tabela2.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 ?
 




 2 Posts in Topic:
select from two tables
"Urbiasz" <a  2008-05-27 16:57:05 
Re: select from two tables
"Plamen Ratchev"  2008-05-27 11:33:50 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Wed Dec 3 0:59:47 CST 2008.