Archives of the TeradataForum

Message Posted: Fri, 05 Aug 2005 @ 13:34:48 GMT

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

     select a.last, a.first, a.code|','|b.code|','|c.code
     from table1 a
     left outer join table1 b
     on (a.last=b.last
     and a.first=b.first)
     left outer join table1 c
     on (a.last=c.last
     and a.first=c.first)

Blaine Vande Berg
VectorSCM - Customer Facing Applications

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