此SQL巨头晕,大家来瞧瞧,该如何解决
日期：2014-05-17 浏览次数：20832 次
此SQL巨头晕,大家来瞧瞧
select distinct (A.CARDID),
A.CARDNO,
A.MEMBERID,
C.MEMBERNO,
C.MemberName,
C.IDNO,
D.cardName,
A.KEEPAMT,
C.Point,
C.STATUS,
A.AMT,
A.TOTAMT,
A.CONSUMAMT,
A.TICKETAMT,
A.CREATEDATE,
A.LASTMODIDATE,
A.VALIDDATE,
A.CARDPROP
from BasCardInfo A
left join BasMemberInfo C
on A.MEMBERID = C.MEMBERID, CardType D,
(select BranCode, cardid, trunc(saledate) as etrunc
from PosItemH
where saledate between to_date('2004-12-01', 'yyyy-mm-dd') and
to_date('2012-12-04', 'yyyy-mm-dd')
and abs(amt) >= 1) E,
(select trunc(saledate) as ftrunc, BranCode, cardid, count(1)
from PosItemH
where trunc(saledate) between to_date('2004-12-01', 'yyyy-mm-dd') and
to_date('2012-12-04', 'yyyy-mm-dd')
group by trunc(saledate), cardid, brancode
having 1 = 1 and count(1) > 1 and brancode in (select BranCode
&nbs
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
