Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
SQL for report
6 views
Skip to first unread message
Lasitha
Jan 10, 2012, 5:14:45 AM1/10/12
to
Hi have query call "ADVBNK"
TBANK TMBOC TMBRAN BANKAMT ROOT
BC CSH KLW 1637770 CL
BC BNK KLW 2434260 CL
SB BNK KLW 1099350 CL
BC BNK DOD 582650 CL
BC BNK KLW 661370 EH
BC BNK KLW 2050160 CL
COM BNK KLW 750920 PMB
PB BNK KLW 678870 CL
in this table I wonna get the sum of "BANKAMT" by filtering
"CL" form "ROOT"
then "BC" from "TBANK"
then "BNK" from "TMBOC"
then "KLW" from "TMBRAN"
to specific Text box of report
pls tell me how to do it with SQL statement of another easy way
TBANK TMBOC TMBRAN BANKAMT ROOT
BC CSH KLW 1637770 CL
BC BNK KLW 2434260 CL
SB BNK KLW 1099350 CL
BC BNK DOD 582650 CL
BC BNK KLW 661370 EH
BC BNK KLW 2050160 CL
COM BNK KLW 750920 PMB
PB BNK KLW 678870 CL
in this table I wonna get the sum of "BANKAMT" by filtering
"CL" form "ROOT"
then "BC" from "TBANK"
then "BNK" from "TMBOC"
then "KLW" from "TMBRAN"
to specific Text box of report
pls tell me how to do it with SQL statement of another easy way
0 new messages