sql query

[Shanky Sohar]

"SELECT QC_CHRG_RATE, QC_LKP_SA FROM QC_CHRG_RATE WHERE QC_RATE_TBL = " + rateTableID +
" AND QC_RATE_TBL_EFF_DT = '" + effDate.getDBFormattedDate() +
"' AND QC_LKP_KEY = '" + lookupKey +
"' AND QC_LKP_AGE2 >= " + lookupAge +
" AND QC_LKP_CLMN_NUM >= " + lookupColumn +
" ORDER BY QC_LKP_AGE2 ASC, QC_LKP_CLMN_NUM ASC";


how this SQL will run

[Fatih Keles]

Hi shanky,

What do you mean by "run"? Are you asking for output, execution plan, logic? Or just how to run it? Can you provide more information about your question, database etc ?

Regards,

Fatih.

[Shanky Sohar]

i wanna know how thw output will be evaluated .........................

[Paul Sturrock]

shanky sohar wrote:i wanna know how thw output will be evaluated .........................

Not sure what you mean here. Can you explain some more?