In previous versions of Oracle (and on SQL Server and DB2), the query below returns 1 record. In Oracle 12c, no records are returned. Is this a known issue in Oracle 12c? CREATE TABLE FOO (id NUMBER, inherit NUMBER(1), parentId NUMBER); INSERT INTO FOO VALUES (1, 0, null); COMMIT; SELECT FOO.id, PARENT.id, GRANDPARENT.id FROM FOO LEFT JOIN FOO PARENT ON FOO.parentId = PARENT.id AND FOO.inherit = 1 LEFT JOIN FOO GRANDPARENT ON PARENT.parentId = GRANDPARENT.id AND PARENT.inherit = 1