照着下面这个思路改 select ... from table1 left outer join table2 on table1.id=table2.id ... ------------------------------------------------------------------------ select ... from table1,table2 where (table1.id=table2.id(+) and table2.id is null) ...
CREATE TABLE MONEY_1 as (select T11.USER_OID NETWORK_ID,) 就可以了
照着下面这个思路改 select ... from table1 left outer join table2 on table1.id=table2.id ...
------------------------------------------------------------------------
select ... from table1,table2 where (table1.id=table2.id(+)
and table2.id is null) ...
就可以了
其中的别名T11在内层子查询中不能识别.