Archives of the TeradataForum

Message Posted: Tue, 28 Oct 2003 @ 12:15:34 GMT

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

Hi,

Actually is just one step. First join tells that tables (B and A) are going to be joined together and there are no where clause (no residual conditions). Second join tells which kind of join is going to happen (merge) and by which columns (CHK.A.a and CHK.B.a).

Henry

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