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 2008 Forums
 Transact-SQL (2008)
 List of [Condensed List as a single cell]

Author  Topic 

morespamforya
Starting Member

1 Post

Posted - 2011-04-13 : 20:06:34
Hi all

Just a small thing that I've done before, but totally forgot about it coz I am idiot.

Let's say I have a relation table of users to cars

So:

User
-------
Ted
Ken

Car
------
Jaguar
Ferrari
Honda
Hyundai


car_user
-----------
Ted : Honda
Ted : Toyota
Ted : Ferarri
Ken : Hyundai



How do I show it as a list of user to cars? As in below:

UserToCars
-----------------------
Ted : Honda, Toyota, Ferarri
Ken : Hyundai

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2011-04-13 : 21:39:48
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=81254


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page
   

- Advertisement -