Archives of the TeradataForum

Message Posted: Wed, 07 Oct 2009 @ 12:07:58 GMT

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

<-- Anonymously Posted: Wednesday, October 07, 2009 08:06 -->

Fetch the distinct values of the colx from Table A(with the help of a subquery) and then join with Table B.

Eg:

     Sel 
     From
     Table_A,(optional when no other columns are being selected from Table_A) (Sel colx from
     Table_A group by 1)GRP_A, Table_B Where GRP_A.colx=Table_B.colx And GRP_A.colx =
     Table_A.colx (optional when no other columns are being selected from Table_A);

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