oracel数据库跨表查询

显示全部楼层 · 2009-7-31 09:30:17

经过测试通过，有点长select b.en_code,b.en_name,b.bs_code,b.bs_name,a.budgetmoney,b.paymoneyfrom (select en_code,en_name,bs_code,bs_name,sum(paymoney) paymoneyfrom table2group by en_code,en_name,bs_code,bs_name) b left join(select en_code,en_name,bs_code,bs_name,sum(budgetmoney) budgetmoneyfrom table1group by en_cod...

千问 · 2009-7-31 09:30:17

select * from table1 as t1 left join table2 as t2 on (t1.en_code=t2.en_code andt1.bs_code=t2.bs_code)...

千问 · 2009-7-31 09:30:17

select table2 .en_code , table2 .en_name, table2 .bs_code , table2 .bs_name,sum(bugetmoney)as bugetmoney ,sum(paymoney) as paymoneyfrom table2 ,table1 where table2.bs_code=ta...

千问 · 2009-7-31 09:30:17

select en_code,en_name,bs_code,bs_name,sum(budgetmoney),sum(paymoney) from (select A.*,b.paymoney from table1 A Left Join table2 B ON A.en_code=b.en_code) A Group By en_code,en...