select a.a1,b.b2,c.c2,d.d2,a.a4
from a,b,c,d
where
a.a1=b.b1 and
a.a2=c.c2 and
a.a3=d.d2 and
a.a5=type
a5 between startdate and enddate
from a,b,c,d
where
a.a1=b.b1 and
a.a2=c.c2 and
a.a3=d.d2 and
a.a5=type
a5 between startdate and enddate
调试欢乐多
FROM B,C,D,A
WHERE A.a1=B.b1 AND A.a2 = C.c1 AND A.a3 = D.d1 AND
(TO_CHAR(A.a5,'YYYY-MM-DD') BETWEEN '' AND '')
'' 中添入相应时间
where
a.a1=b.b1 and
a.a2=c.c1 and
a.a3=d.d1 and
a.a6='type_name' and a.a5 between startdate and enddategroup by b.b1,b.b2,c.c2,d.d2
Select b.b1,b.b2,c.c2,d.d2,Sum(a.a4) From a,b,c,d
where
A.a1=b.b1 and
A.a2=c.c1 and
A.a3=d.d1 and
A.a6='类别'and a.a5 Between startdate End enddateGroup By b.b1,b.b2,c.c2,d.d2