Table: Customer (Id, Name) has 3 records
Table: Order (Id, Order_Date) has 15 records
Select * From Customer, Order
Above query returns 15 records. This is also known as Cartesian Product.
For a table with N records and another table with M records. Cartesian Product has N * M number of records.Read the full book at www.amazon.com