uuuu--convert many rows into one row

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 2005 Forums

Transact-SQL (2005)

uuuu--convert many rows into one row

Author

Topic

Sarakumar
Posting Yak Master

108 Posts

Posted - 2009-03-13 : 03:48:06

Hai,
i have two tables, one with customer detail another with prod detail.
for one customer there will be mulitple row in the prod table..
but when i want to display the report, i just want to display only one line information

following like this

John PC&LAPTOP&HEARPH
Stew PC&LAPTOP

how can i write a query for this..
table structre is like the following

Customer table
cust_id
cust_name
cust_Address

Product table
Prod_id
cust_id
Prod_des

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-03-13 : 03:53:58

See http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=81254

E 12°55'05.63"
N 56°04'39.26"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources