Cross join or Cartesian Product Join
This type of join displays multiplication of rows of two tables. It means if table A have 5 rows and table B have 4 rows then cross join will display total 20 rows.
e.g.
select * from A cross join B;
Above query will display all 20 rows (5*4).
No comments:
Post a Comment