I am trying to run this query, When I run it it gives me program error "Key Invalid Length". Any help.
Thanks
Bharat

SELECT _4_claim_temp_header.claim_num as Header_Claim,;
Batch_rpt.claim_num as SS_Claim,;
Claim_detail.line, _4_claim_temp_header.batch_num,;
_4_claim_temp_header.pat_lname, _4_claim_temp_header.pat_fname,;
Claim_detail.serv_beg, Claim_detail.serv_end, Claim_detail.serv_cpt,;
Claim_detail.serv_mod, Claim_detail.serv_units,;
Claim_detail.fee_sched_amt as fee, Claim_detail.allowed_amt as Billed,;
Claim_detail.provider_pay as prov;
FROM batch_rpt, _4_claim_temp_header, claim_detail;
where;
batch_rpt.claim = _4_claim_temp_header.ins_policy and;
Batch_rpt.pat_fname = _4_claim_temp_header.pat_fname and;
Batch_rpt.pat_lname = _4_claim_temp_header.pat_lname and;
Batch_rpt.ssn = _4_claim_temp_header.enrollee and;
Batch_rpt.pre_auth = _4_claim_temp_header.prior_auth and;
Batch_rpt.end = Claim_detail.serv_end and;
Batch_rpt.start = Claim_detail.serv_beg and;
Batch_rpt.units = Claim_detail.serv_units and;
Batch_rpt.billed = Claim_detail.allowed_amt and;
Batch_rpt.fee = Claim_detail.fee_sched_amt and;
Batch_rpt.prov = Claim_detail.provider_pay and;
Batch_rpt.mod = Claim_detail.serv_mod and;
Batch_rpt.code = Claim_detail.serv_cpt and;
_4_claim_temp_header.claim_num = Claim_detail.claim_num and;
_4_claim_temp_header.claim_num <> Batch_rpt.claim_num and;
Claim_detail.serv_cpt <> "E1399" and;
Claim_detail.remarks2 = "15" ;
ORDER BY _4_claim_temp_header.claim_num