MySQL Forums
Forum List  »  Newbie

Cross join result sequence
Posted by: Neeraj Mahajan
Date: July 08, 2015 09:56AM

If we have two tables and we do a cross join (cartesian product) on both tables then what will be the sequence of records after cross join. Will there be any sequence impact if number of records changes in any of the tables ?

For example if we two tables tab1 and tab2 then what will be the output of SELECT * from tab1, tab2

tab1

column1 column2
10 100
20 200
30 300

tab2

column1
40
41
42
43

Options: ReplyQuote


Subject
Written By
Posted
Cross join result sequence
July 08, 2015 09:56AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.