DEV Community

Discussion on: SQL: Basics to Advanced in a Nutshell

rksainath profile image
Sainath Ramanathan Author

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.