select a.organizationname, c.monthmoney from basorganization a, (select sum(a.monthmoney) as monthmoney, b.parentorganizationid from v_salesorder_monthreport a, basorganization b where a.orgid = b.organizationid and (to_char(a.monthdate, 'yyyy-MM')) = '2010-12' group by b.parentorganizationid) c where c.parentorganizationid = a.organizationid and a.organizationtype = 2;可以查询出有相符的信息
select a.organizationname, c.monthmoney from basorganization a left outer join (select sum(a.monthmoney) as monthmoney, b.parentorganizationid from v_salesorder_monthreport a, basorganization b where a.orgid = b.organizationid and (to_char(a.monthdate, 'yyyy-MM')) = '2010-12' group by b.parentorganizationid) c on c.parentorganizationid = a.organizationid where a.organizationtype = 2;改成left outer join 就查不出来了
from basorganization a,
(select sum(a.monthmoney) as monthmoney, b.parentorganizationid
from v_salesorder_monthreport a, basorganization b
where a.orgid = b.organizationid
and (to_char(a.monthdate, 'yyyy-MM')) = '2010-12'
group by b.parentorganizationid) c
where c.parentorganizationid = a.organizationid
and a.organizationtype = 2;可以查询出有相符的信息
select a.organizationname, c.monthmoney
from basorganization a left outer join (select sum(a.monthmoney) as monthmoney, b.parentorganizationid
from v_salesorder_monthreport a, basorganization b
where a.orgid = b.organizationid
and (to_char(a.monthdate, 'yyyy-MM')) = '2010-12'
group by b.parentorganizationid) c
on c.parentorganizationid = a.organizationid
where a.organizationtype = 2;改成left outer join 就查不出来了