mercredi 4 novembre 2015

I'm trying to return a single row of a service order number Table A along with multiple comments from Table B

Here is what I have.

 SELECT sh.[No_], scl.[Date], scl.[Comment]
 from   [Service Header] sh left join [Service Comment Line] scl
    on sh.[No_] = scl.[No_]
 where sh.[No_] = 'SVO-16657'

It returns this:

    NO.             DATE                 COMMENT

 SVO-16657  2015-10-02 00:00:00.000     PART IS READY FOR PICK UP.
 SVO-16657  2015-10-15 00:00:00.000     CONVERSION KITS SHIPPED 10/19/15.
 SVO-16657  2015-10-21 00:00:00.000     ALL OTHER MATERIAL SHIPPED 10/23/15.
 SVO-16657  2015-10-02 00:00:00.000     READY FOR PICK UP.
 SVO-16657  2015-10-15 00:00:00.000     CONVERSION KITS SHIPPING 10/16/15.
 SVO-16657  2015-10-21 00:00:00.000     ALL OTHER MATERIAL SHIPPED.

I want it to read

 SVO-16657  10/2/2015 PART IS READY FOR PICK UP | 10/15/2015 CONVERSION KITS    SHIPPED 10/19/15 | 10/21/2015 ALL OTHER MATERIAL SHIPPED 10/23/15...AND SO ON

Aucun commentaire:

Enregistrer un commentaire