SQL for report

[Lasitha]

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