Peeps,
I'm getting an "ORA-00937: not a single group group function error" when I try and run the following query. Any help is appreciated:
SELECT tbt.major_cov_cd||', '||
tbt.claim_id||', '||
tbt.accident_date||', '||
tbt.carrier_notified_date||', '||
tbt.accident_date||', '||
tbt.close_date||', '||
tbt.reopen_date||', '||
tbt.claim_status_cd_o||', '||
tbt.medbicl_inc||', '||
tbt.medbicl_inc||', '||
to_char(nvl(med_rdate,tbt.carrier_notified_date),' MM/DD/YYYY') ||', '||
tbt.medbicl_pd||', '||
tbt.recov_pd||', '||
tbt.indpdcp_inc||', '||
tbt.indpdcp_inc||', '||
to_char(nvl(ind_rdate,tbt.carrier_notified_date),' MM/DD/YYYY') ||', '||
tbt.indpdcp_pd||', '||
tbt.Expense_inc||', '||
tbt.Expense_inc||', '||
to_char(nvl(exp_rdate,tbt.carrier_notified_date),' MM/DD/YYYY') ||', '||
tbt.expense_inc||', '||
substr(clmt_name, 1, instr(tbt.clmt_name, ' ') -1) ||', '||
substr(clmt_name, instr(tbt.clmt_name, ' '), length(clmt_name))||', '||
tbt.policy_number||', '||
tbt.branch_file
FROM sti_data.scd_claims_tbt tbt,
(SELECT fd.claim_carrier_key,
min(case when fd.trn_category_cd='MEDBICL' and fd.TRN_RESERVE >0 then fd.eval_date else null end) med_rdate,
min(case when fd.trn_category_cd='INDPDCP' and fd.TRN_RESERVE >0 then fd.eval_date else null end) ind_rdate,
min(case when fd.trn_category_cd='EXPENSE' and fd.TRN_RESERVE >0 then fd.eval_date else null end) exp_rdate
FROM sti_data.scd_financial_detail fd) fd
where fd.claim_carrier_key = tbt.claim_carrier_key