- 论坛徽章:
- 0
|
SQL语句如下:
SELECT unitname, SUM(amount), datatype, defraymode, datasource
FROM (SELECT
(SELECT u.unitname
FROM mm_unit_tc u
WHERE u.unitcode = p.unitcode) unitname,
SUM(amount) amount,
datatype datatype,
defraymode defraymode,
p.datasource datasource
FROM mm_payablemoney_td p
WHERE p.subcompany = v_subcompany
AND p.opstatus IN ('0', '1')
AND p.opdate BETWEEN v_startdate
AND v_enddate
GROUP BY unitcode, defraymode, datatype, datasource
ORDER BY unitcode, defraymode, datatype, datasource)
GROUP BY unitname, defraymode, datatype, datasource
请问高人select ..........from之间可以放嵌套查询语句吗? 什么意思啊,为什么啊。。高人能否解释下啊? |
|