Re: Problem with Left joins and WHERE clause
...a left join b on a.i=b.i... returns all rows in a attached to matching rows on i in b where they exist, otherwise rows from a with nulls for values from b. Tutorial at
http://www.mysqltutorial.org/mysql-left-join.aspx
If you want only matches from the two tables. use inner join ie remove the word 'left'.
Subject
Written By
Posted
February 11, 2019 03:56AM
Re: Problem with Left joins and WHERE clause
February 11, 2019 10:59AM
February 11, 2019 01:35PM
February 11, 2019 01:36PM
February 11, 2019 01:41PM
February 12, 2019 12:33AM
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.