0 - 4 of 4 tags for product join

Hi All
I have two tables like below with sample data:
   ID_COL            |     REF_COL
    123                  |     Desc_123
    100                  |     200_payout

Problem Description
A typical lookup kind of JOIN between FACT table with hundreds of millions of web clicks, and DIM table with 55M IP ranges in numeric style (e.g. downloaded from MaxMind).

I've recently noticed that the Teradata parsing engine doesn't pick up on / given an error for 'accidental cartesians' or, to use another term to make it more clear why I think this is a significant bug, 'unreferenced / unqualified tables'.

Hi !

I want to know if there any difference between Product Join and Cartesian Product Join ?
If not then why do we have separate Join strategies as Product and Cartesian in Teradata ?

Nitin 'Raj' Srivastava