How to Break a MySQL Left Join
Care must be taken when placing conditions on the results of the right-hand table of a LEFT JOIN because it could easily become a normal JOIN since MySQL is using a NULL row for every column in the right-hand table when no records exist.
Tags : database how-to programming
You will be redirected to How to Break a MySQL Left Join, in 20 seconds.