Selecting Distinct for a Condition B-)

[LeonelSanchezJr]

My query returns records as such:

DOCNUMBER DOCTYPE
123 ABC
123 DEF
123 GHI
123 POD

I WANT TO COMBINE THE 3 ROWS FOR DOCNUMBER 123 AND DOCTYPE
BEING ABC, DEF, GHI INTO ONE ROW SAYING DOCTYPE 'ABC,DEF,GHI'. I want to keep row 123 with Doctype POD as a row by itself.

 

[ludmart]

Please supply more info, then someone may be able to assist.

 

[LeonelSanchezJr]

My query returns records and are displayed in my report as below:

DOCNUMBER DOCTYPE
123 ABC
123 DEF
123 GHI
123 POD

I WANT TO COMBINE THE 3 ROWS FOR DOCNUMBER 123 AND DOCTYPE
BEING ABC, DEF, GHI INTO ONE ROW SAYING DOCTYPE 'ABC,DEF,GHI'. I want to keep row 123 with Doctype POD as a row by itself.

I want the records to be displayed as such:

DOCNUMBER DOCTYPE
123 ABC, DEF, GHI
123 POD

Basically the DOCTYPES ABC, DEF, and GHI belong together on one row, but the POD belong on a separate line.

 

[TVernon]

So something like this?

SELECT MAX(DOCNUMBER) AS DOCNUMBER, CASE WHEN DOCTYPE IN ('ABC', 'DEF', 'GHI') THEN 'ABC, DEF, GHI' ELSE DOCTYPE END AS DOCTYPE FROM ???? GROUP BY CASE WHEN DOCTYPE IN ('ABC', 'DEF', 'GHI') THEN 'ABC, DEF, GHI' ELSE DOCTYPE END