In RIGHT OUTER JOIN, all rows from the right table are included, unmatched rows from the left are replaced with NULL values. So to get those unmatched data explicitly, WHERE keyword with a condition IS NULL is used. As you said you can simply eliminate the WHERE condition and see for yourself for a better understanding.
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
In
RIGHT OUTER JOIN
, all rows from the right table are included, unmatched rows from the left are replaced withNULL
values. So to get those unmatched data explicitly,WHERE
keyword with a conditionIS NULL
is used. As you said you can simply eliminate the WHERE condition and see for yourself for a better understanding.