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