MySQL Forums
Forum List  »  Optimizer & Parser

Advanced Search
New Topic

Re: inner join vs left join - huge performance difference
Posted by: Isabella Swan
Date: September 27, 2016 07:13AM

INNER JOIN gets all records from one table that have some related entry in a second table.

LEFT JOIN gets all records from the LEFT linked table but if you have selected some columns from the RIGHT table, if there is no related records, these columns will contain NULL.

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




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.