Archives of the TeradataForum

Message Posted: Wed, 18 Aug 2004 @ 14:30:16 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Use UNION

     sel name
     ,'SHIRT'
     FROM TEST_01
     WHERE
     SHIRT=1
     UNION
     sel name
     ,'PANTS'
     FROM TEST_01
     WHERE
     PANTS=1
     (ETC)
     ORDER BY 1,2

	<Prev	Next>		<<First	<Prev	Next>	Last>>