SQL如下:
SELECT shoufeirq, menzhensr, zhuyuansr FROM (
select shoufeirq,sum(menzhensr) menzhensr from report_jrdt_menzhensr group by shoufeirq) a
left join
(select jiezhangrq,sum(zhuyuansr) zhuyuansr from report_jrdt_zhuyuansr group by jiezhangrq) b
on a.shoufeirq = b.jiezhangrq
where shoufeirq =to_char(TO_DATE( #PROMPT('P_DATE')#, 'YYYY-MM-DD'),'yyyymmdd' )
其中P_DATE是傳入SQL的引數
uj5u.com熱心網友回復:
傳過來的引數是什么?轉載請註明出處,本文鏈接:https://www.uj5u.com/shujuku/62129.html
標籤:開發
