If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
group by .....?
hello , can anybody help me on this....
i have the following query... SELECT A.A1,A.A2,A.A3,A.A4, B.B1, B.B2, B.B3, B.B3, B.B4, B.B5, B.B6, B.B6, C.C1,C.C2,D.D1,D.D2,D.D3,D.D4,D.D5,D.D6,D.D7,(D3+D 4+D5+D6-D7) AS TOTALperRecord FROM A INNER JOIN (B LEFT JOIN (C LEFT JOIN D ON C.C1 = D.D1) ON B.B1 = C.C2) ON A.A1 = B.B2 HAVING (((B.B3]) Between #1/1/2007# And Date()) AND ((B.B4)=No) AND C.C2)=No) AND ((C.C1)=Yes)) ORDER BY A.A1; im using A,B,C,D because they r in greeks characters... the D's values r currency. i want to group the *totalPerRecord* euro value from the forth table per B1 value which is an autonumberID in my second table. Thanks |
Thread Tools | |
Display Modes | |
|
|