Archives of the TeradataForum

Message Posted: Wed, 18 Jun 2014 @ 23:20:59 GMT

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

There are two groups of tables/views:

View1, View1_list, View3 and tax_rans_list

View2, tax_acct_list, Transaction

There are join conditions to relate the tables in each group together but no conditions that relate the two groups of tables together - therefore OPT has no choice but to product join.

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