Multiple tables (5. Left Joins)


#1

Trying to get the left join challenge but the editor shows me the error: Did you remember to add the WHERE clause?
This is my code:

SELECT *
FROM newspaper
LEFT JOIN online
	ON newspaper.id = online.id
WHERE online.id IS NULL;

What can be wrong?


#2

Finally clicked the “get solution” button and found out that the code is correct. So i guess the checker is failing if you removed the query from step 1.

The error message should be a “Do not remove first query” or “Keep the query from step 1” but no “Did you remember to add the WHERE clause?”


#3

Wow thank you, took me hours to find this!


#4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.