what is the difference between cartesian product and join?
Cartesian product means you will have rows with each record from one table matched with all rows of second table. ... If you will use join, you will have keys which will be able to join rows from first table with rows of second table and depending on your relation, number of rows may vary.