Ahhh...


Well, for completeness sake, I can show you how to do that anyway.

If you ever have an issue where you can't *directly* use an outer join, you must 'wrap' that inside an in-line view. To wit:

select p.plat_id,
a1.thisandthat a1_thisandthat,
b1.somethingorother b1_somethingorother,
a2.thisandthat a2_thisandthat,
b2.somethingorother b2_somethingorother
from platform p,
(select thisandthat, org_idm plat_id from table1 where code in (a,b,c,d)) a1
table2 b1,
(select thisandthat, org_idm plat_id from table1 where code in (a,b,c,d)) a2
table2 b2
where p.plat_id = a1.plat_id(+)
and a1.org_id = b1.org_id(+)
and p.plat_id = a2.plat_id(+)
and a2.org_id = b2.org_id(+)

Of course, as soon as you do this, you change the plan significantly, so you will have that to worry about, but this is the basic solution

- Chris