 |
 |
Archives of the TeradataForum
Message Posted: Wed, 21 Feb 2007 @ 20:44:50 GMT
| Subj: | | Re: Avoid the Product Join |
| |
| From: | | Castelli Emanuel Alejandro |
Jon Christie wrote:
| | The only way to avoid a product join is to supply a connecting term between the tables where the operator of the term is =. (These terms
are called BIND TERMS.) Product joins are the only join type that can join two tables without a bind term. That's why you're getting a product
join. | |
Sorry, but what do yo mean with "term"?
Can you give me an example with the query i'd supplied?
Thanks.
Castelli, Emanuel Alejandro
Desarrollo DataWarehouse - IBM Argentina
| |
