Converting RIGHT JOIN to LEFT OUTER JOIN for fetching the same data

Question

I have a table named Persons with the following data

The following query will fetch me the pid value in Persons table which is not equal to any of the PersonId values :

select B.pid
from Persons A
RIGHT JOIN Persons B ON (A.PersonID = B.pid)
where A.PersonID IS NULL
  AND B.pid IS NOT NULL

Is there a way to fetch the same data using LEFT OUTER JOIN?

possible duplicate of [Difference between left join and right join in SQL Server](http://stackoverflow.com/questions/4715677/difference-between-left-join-and-right-join-in-sql-server) — amdixon, Sep 16 '15 at 12:06

score 1 · Answer 1 · answered Sep 16 '15 at 11:49

1

You should get the same result using left join, just by reversing the tables:

select B.pid
from Persons B LEFT JOIN
     Persons A
     ON A.PersonID = B.pid
where A.PersonID IS NULL AND B.pid IS NOT NULL

answered Sep 16 '15 at 11:49

Gordon Linoff

like... without using that B.pid IS NOT NULL in the original query.. will a left outer join help with that? – Sep 16 '15 at 12:07

1 Answers1