UC知道求助：sybase嵌套查询
来源：百度知道 编辑：UC知道 时间：2024/06/23 13:44:20
大家看看这个嵌套那错了。帮我改改看看。。
select en cardbin, ed cardname, sum(cc) scount,oo OperatorID from
(select B.entryName en, B.entryDesc ed, A.cardbin cb, A.cardscount cc, A.operatorid oo from
(select cardbin, operatorid, count(*) cardscount from NoPrintCard where 1=1 and reqno='1' group by cardbin, operatorid ) A,
(select cfentry.entryno, entryName, entryDesc, cardbin from domcardstat cfentry, domstatcardbin decardbin where cfentry.entryno = decardbin.entryno ) B
where A.cardbin = B.cardbin) group by en, ed,oo
select en cardbin, ed cardname, sum(cc) scount,oo OperatorID from
(select B.entryName en, B.entryDesc ed, A.cardbin cb, A.cardscount cc, A.operatorid oo from
(select cardbin, operatorid, count(*) cardscount from NoPrintCard where 1=1 and reqno='1' group by cardbin, operatorid ) A,
(select cfentry.entryno, entryName, entryDesc, cardbin from domcardstat cfentry, domstatcardbin decardbin where cfentry.entryno = decardbin.entryno ) B
where A.cardbin = B.cardbin) group by en, ed,oo
还是教你一个小窍门，不仅限此题：
要讲好一门课程，首先必须对这门课程的内容下功夫钻研，不但要做到深刻理解，而且要做到全面掌握。这样才能适当选择教材和妥善安排教材。所谓深刻理解，就是要把课程内容的每一个组成部分都彻底搞懂，不能有一点含糊，准备回答学生们可能提出的一连串的“为什么”。