MySQL Forums
Forum List  »  Newbie

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.

Options: ReplyQuote


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


Sorry, only registered users may post in this forum.

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.