Archives of the TeradataForum

Message Posted: Fri, 24 Jun 2005 @ 20:40:23 GMT

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

One possible crude method to achieve this is to use a query like below

     SELECT TBLA.CUST,TBLA.ACCT,TBLA.BAL,
                                     TBLB.ACCT,TBLB.BAL,
                                     TBLC.ACCT,TBLC.BAL
     FROM TBL1 TBLA,
                TBL1 TBLB,
                TBL1 TBLC
     WHERE
     TABLA.CUST=TABLB.CUST AND
     TABLB.CUST=TABLC.CUST AND
     TABLA.ACCT=100 AND
     TABLB.ACCT=200 AND
     TABLC.ACCT=300

Thanks,

Kambhoji.

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