Why nested loop is giving incorrect result?


SELECT reviewer_name
FROM reviewers
WHERE reviewer_id = (
FROM ratings
WHERE reviewer_stars = NULL


Your first = need to be replaced by in and second “=” by is


@gaurav.pandey1234546 After doing this, the query which becomes has no joins.
But is it internally using a join? If yes, which type?
I don’t think it is using any join since the bracket is evaluated first; then its output serves as input to first SELECT.