I have a select statement with the following fields (FFDCUSN, FFDCSCD, FFDCGRP, FFDCTPE) see image but altered to provide repeated CUSN for each of the other fields.
I need a query that will return the FFDCUSN with a column containing the values for each of the additional column that contains a form of customer grouping. See prefered output image below: I figure this needs to be a self join but can't quite wrap my brain around the formating
asked Feb 26, 2015 at 07:09 PM in Default
answered Feb 26, 2015 at 07:16 PM