PS,
I've tried a COALESCE as mentioned in an earlier post here on LDBA, but
that only gives me this (lists ALL the Products, instead of only the
ones mapped to the correct ID):
ProdID Product
-------- ---------------
10 222, 333, 777, 888
20 222, 333, 777, 888
-----Original Message-----
From: Julius Ghyoot
[mailto:mssqldba-ezmlmshield-x16875015.[Email address protected]
Sent: Wednesday, 30 April 2008 2:40 p.m.
To: LazyDBA Discussion
Subject: SQL Results Formating.
Hi Guys
Please help!
I have this query:
Select
d.ID AS ProdID,
p.Product
FROM tblDETAILS d
LEFT OUTER JOIN tblPRODUCT p ON d.ID = p.ID
Which Returns this:
ProdID Product
----------- ------------
10 222
10 333
20 777
20 888
(2 row(s) affected)
But I want it formatted like this:
ProdID Product
----------- ---------------
10 222, 333
20 777, 888
Is this possible?
Thanks
Julius
____________________________________________________________
This e-mail and any attachments may contain confidential information. If
you
are not the intended recipient (or have received this e-mail in error)
please notify the sender immediately and destroy this e-mail. Any
unauthorized copying, disclosure or distribution of the material in this
e-mail is strictly forbidden.
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
____________________________________________________________
This e-mail and any attachments may contain confidential information. If you
are not the intended recipient (or have received this e-mail in error)
please notify the sender immediately and destroy this e-mail. Any
unauthorized copying, disclosure or distribution of the material in this
e-mail is strictly forbidden.
MS Sql Server LazyDBA home page