ORA-00937 not a single group group function

[Hollywood_Jack]

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_c d||', '||
tbt.claim_id||' , '||
tbt.accident_da te||', '||
tbt.carrier_not ified_date||', '||
tbt.accident_da te||', '||
tbt.close_date| |', '||
tbt.reopen_date ||', '||
tbt.claim_statu s_cd_o||', '||
tbt.medbicl_inc ||', '||
tbt.medbicl_inc ||', '||
to_char(nvl(med _rdate,tbt.carr ier_notified_da te),' MM/DD/YYYY') ||', '||
tbt.medbicl_pd| |', '||
tbt.recov_pd||' , '||
tbt.indpdcp_inc ||', '||
tbt.indpdcp_inc ||', '||
to_char(nvl(ind _rdate,tbt.carr ier_notified_da te),' MM/DD/YYYY') ||', '||
tbt.indpdcp_pd| |', '||
tbt.Expense_inc ||', '||
tbt.Expense_inc ||', '||
to_char(nvl(exp _rdate,tbt.carr ier_notified_da te),' MM/DD/YYYY') ||', '||
tbt.expense_inc ||', '||
substr(clmt_nam e, 1, instr(tbt.clmt_ name, ' ') -1) ||', '||
substr(clmt_nam e, instr(tbt.clmt_ name, ' '), length(clmt_nam e))||', '||
tbt.policy_numb er||', '||
tbt.branch_file
FROM sti_data.scd_cl aims_tbt tbt,
(SELECT fd.claim_carrie r_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_fi nancial_detail fd) fd
where fd.claim_carrie r_key = tbt.claim_carri er_key

[Hollywood_Jack]

I figured it out. In my second select statement, I had to add the following:

(SELECT fd.claim_carrie r_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_fi nancial_detail fd
group by fd.claim_carrie r_key) fd
where fd.claim_carrie r_key = tbt.claim_carri er_key