Saturday 18 May 2013

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