displaying multiple values in a 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

General SQL Server Forums

New to SQL Server Programming

displaying multiple values in a column

Author

Topic

rameshkumar
Starting Member

1 Post

Posted - 2010-06-09 : 06:19:13

i have 3 tables company,owner,co-owner.
company owner co-owner
cid cid cid
cname oid coid
ccity ocity cocity

from this table i want to fetch data and tat should bedisplayed as below

cid name
1 rkexports(company name)
ram(owner)
raj(co-owner)
2 fdkmanufacturers(cn)
kumar (o)
smith(co)
etc
can anyone help me with this with query

DonAtWork
Master Smack Fu Yak Hacker

2167 Posts

Posted - 2010-06-09 : 08:22:06

Display issue = Front End issue.

http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx
How to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx
For ultra basic questions, follow these links.
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp

GhantaBro
Posting Yak Master

215 Posts

Posted - 2010-06-09 : 14:43:45

Try using pivot table.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources