Report SQL

-- Sub-query mode

Select r. Organnorec. R. Organname. sum (r.vrc), sum (r.psatf), sum (r.vtf), (select a.rate from tb_accrate a where a.organno=r.organno and a. Classttypedia. 03') from TBC_QRCODEPOISE_REP r group by r. Organno. R. Organname

-- Associated query method

SELECT T. SUM, A.RATE FROM (SELECT R.ORGANNO, R.ORGANNAME, SUM (R.VRC), SUM (R.PSATF), SUM (R.VTF))

FROM TBC_QRCODEPOISE_REP R GROUP BY R.ORGANNO, R.ORGANNAME) T

LEFT JOIN TB_ACCRATE A

ON T.ORGANNO = A.ORGANNO

AND A.ACCOUNTTYPE = '03'

WHERE T.ORGANNO IN (SELECT A.ORGANNO FROM TB_ACCRATE A WHERE A.ACCOUNTTYPE = '03')

-- displayed according to the quantity of the rate table

SELECT A.ORGANNOCHO.ORGANNAME FROM TB_ACCRATE A (T.VRC), nvl (T.PSATF), ORGANNAME (T.VTF), ORGANNAME A

LEFT JOIN TB_ORGAN O ON A.ORGANNO=O.ORGANNO

LEFT JOIN (SELECT R.ORGANNO, R.ORGANNAME, SUM (R.VRC) VRC, SUM (R.PSATF) PSATF, SUM (R.VTF) VTF

FROM TBC_QRCODEPOISE_REP R where R.WORKDATE > = TO_DATE ('2018-02-25mm AND R.WORKDATE) AND R.WORKDATE