apattin wrote:
I suspect it's a combiantion of GROUP BYs and CASE, but I can't find
the correct syntax. Is this even possible without some procedural code?
Correct. There is one more incredient: MAX()
MAX(CASE WHEN cat3 = 'Primary' then number END) AS "X-primary"
Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab