- SQL INNER JOIN: It returns the records (or rows) present in both tables, If there is at least one match between columns.
- SQL CROSS JOIN: It returns the Cartesian product of both the tables. Cartesian product means Number of Rows present in Table 1 Multiplied by Number of Rows present in Table 2.
Dot Net Tricks 