27,579
社区成员
发帖
与我相关
我的任务
分享
http://bbs.csdn.net/topics/390300746?page=1
SELECT TD004,SUM(TD08),'O' FROM (SELECT TD004,TD008+TD024-TD009-TD025 TD08 from COPTD where TD021 = 'Y' AND TD016 = 'N' AND TD008+TD024-TD009-TD025 > 0 union all SELECT TB003,TB004-TB005 FROM MOCTB left join MOCTA ON TB001+TB002=TA001+TA002 WHERE TA013='Y' AND TA011 < 'Y' AND TB004>TB005)B GROUP BY TD004
这个语句看一下执行计划。