Some sample data will be helpful. Either the table DDL and inserts, or a 'with' query to make it clear what the data and relation(s) are supposed to be, like this:
select p.id, p.fname [, ...] from parent p
If your subchildren table is empty ... how is that relevant to whether or not the query works?
with parent as ( select 1 id, 1 childid from dual union select 2, NULL from dual union select 3, NULL from dual ), child as ( select 1 id, 0 subchildid from dual ) select p.id, p.childid, c.id from parent p left outer join child c on p.childid = c.id
I'd suggest using a different tool. Tools are supposed to aid, not hinder or add ambiguity to tasks.its generated by a tool and I don't have much control over it.
Which version? 11g? 11gR2? or R1? 10g?works as expected in Oracle Standard