Joining multiple fields into one

[jennann]

hi!.. I have been stuck for many hours in this problem.. Let's say in my table1, I have 3 columns:
PrintingID ArtistName EditorName
1111 name1 editor1
1111 name2 editor2
2222 name2 editor3

I wanted to display

PrintingID ArtistName EditorName
1111 name1, name2 editor1,editor2
2222 name2 editor3

Is it possible?

 

[jmcilhinney]

Are we talking about a database table? If so then this is not a VB.NET question. It will be done in SQL code by the database. That is called a "pivot" query, so you should search online for information on that topic.

 

[jennann]

I'm sorry, I mean I'm using vb.net..and sql server 2005 also..

pivot query? ok thnaks i'll google it..

 

[jennann]

Unfortunately, I could not find a simpler examples, :miserable:

 

[jmcilhinney]

You spent all of 17 minutes on the search. That is not nearly sufficient time for a proper investigation.

 

[jennann]

I was searchin for almost 12 hours, then for the last few minutes, since you told me that it was a pivot query, I've search again and most of it that came out are the same threads/information I have searched before, I could not find simpler.. so if it's what you say, i'll try harder...

 

[jmcilhinney]

I've never used a pivot query myself but I just searched for less than a minute and saw several sources that I would be reading if I needed to do this myself. It would take longer than 17 minutes just to read them.

 

[jennann]

I see, as I've said it's not 17 minutes that I've searched for it, I've already read some of the threads that I've found for the past few hours before when I searched for pivot query.. Thank you for you time, I'll find a way to solve it.