Multiple tables (5. Left Joins)

Get Help SQL
#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 Likes
#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.