SQL is as follows:
The SELECT shoufeirq menzhensr, zhuyuansr FROM (
The select shoufeirq, sum (menzhensr) menzhensr from report_jrdt_menzhensr group by shoufeirq) a
Left the join
(select jiezhangrq, sum (zhuyuansr) zhuyuansr from report_jrdt_zhuyuansr group by jiezhangrq) b
On a.s houfeirq=b.j iezhangrq
Where shoufeirq=to_char (TO_DATE (# PROMPT (' P_DATE ') #, 'MM - DD YYYY -'), 'yyyymmdd')
P_DATE is introduced into SQL parameter

CodePudding user response:

The parameter is coming?