In testing TEIIDSB-213 I can see that a query such as:

select a1.id from Account a1 inner join account a2 on a1.parentid = a2.id

actually returns results, but no are expected.

Whereas

select a1.id from Account a1 where a1.parentid is not null

returns no results as expected