joining 2 column into one column

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

joining 2 column into one column

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-11-12 : 09:27:28

noval writes "dear all,
i realy need help right now immediatelly...i hope you will be kind enough to help me, well lets to the point,

i have tabel A and columns are [customer name], [origin site id], [destination site id]

i want to make a report in a new query that consist of all customer and their sites id (both origin and destination)

but the problem is, we have to pick distinct origin site id, distinct destination site id and then combine those distinct column become one column, and we have to avoid repetition from both origin site id and destination site id

in short like this


[customer name]   [origin site id]    [destination site id]
aaa                bbb                ccc
aaa                ccc                ddd
eee                fff                ggg

become

[customer name]    [sites]
aaa                bbb
aaa                ccc
aaa                ddd
eee                fff
eee                ggg

thank you"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources