General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Query is not working
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only