MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

if we can get result using left join by shuffling tables order so why does right join needed or made?
Posted by: Saurabh Mishra
Date: April 24, 2018 09:17AM

Hi, one ask me why does right join made if we can get result just by shuffling table's order for left join? can anyone please share technical reason for this? like because of performance or any other reason.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
if we can get result using left join by shuffling tables order so why does right join needed or made?
Saurabh Mishra
April 24, 2018 09:17AM
Re: if we can get result using left join by shuffling tables order so why does right join needed or made?
Peter Brawley
April 24, 2018 10:23AM


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.