>> Too many subqueries. >>>>
>> >> >>Select a.sif_no, b.insured, a.pol_status As pol_st_old,b.pol_status As pol_st_new, ; >> a.est_prem, o.exp_mod As exp_mod_pct , b.incep_date, ; >> NVL(e.PCT,0)As PCT , Nvl(F.Cnt,0) As NSF, Nvl(g.cancel_cnt,0) As no_pays, ; >> a.agent_no, h.agent_status,Nvl(a.ctp,.F.)As ctp,Nvl(a.consent_rate,.F.) As consent_rate ; >> ,Nvl(i.flag7500," ")As flag_7500 , Nvl(i.res_premium,000000) As res_7500_prem, ; >> NVL(j.res_premium,00000) As res_3000_prem, Nvl(j.flag3000," ") As flag_3000 , ; >> NVL(a.other_flag," ") As other_flag , Nvl(a.other_pct,0) As other_pct ,; >> NVL(k.lr_pct,0) As lr_pct , Nvl(l.cnt50000,0) As cnt50000 , Nvl(m.lr_policy,00000.0)As lr_policy, ; >> NVL(N.frequency,0000) As frequency, ; >> IIF(Empty(a.safety_pct) ," ","Y") As drugfree_cr,IIF(Empty(a.drugfree_pct) ," ","Y") As safety_cr, ; >> IIF(Empty(a.fccpap_pct) ," ","Y") As fccpap_cr, ; >> ICASE(a.limit1 = "500000","2",a.limit1 = "1000000","3"," ") As limits, Iif(a.bill_method = "2","Y", " ") As msa, ; >> 00 As sort_order, a.ctr_pct, a.ctp_ann, 000 As scorecard,Space(4) As star_lr ,Space(1) As star_50000, ; >> SPACE(1) As star_freq,Space(1) As star_no_pay,Space(1) As star_nsf,Space(1) As star_exp_Mod,Space(1) As star_audit, ; >> SPACE(1) As star_7500,Space(1) As star_3000,Space(1) As star_unappr ; >> From tmpPolicy a ; >> LEFT Join h:\ps_vfp\Master b On a.sif_no = b.sif_no ; >> LEFT Join tmpAudit e On a.sif_no = e.sif_no ; >> LEFT Join tmprtn_ck F On a.sif_no = F.sif_no ; >> LEFT Join tmpcancels g On a.sif_no = g.sif_no ; >> LEFT Join tmpagents h On a.agent_no = h.agent_no ; >> LEFT Join tmp_7500 i On a.sif_no = i.sif_no ; >> LEFT Join tmp_3000 j On a.sif_no = j.sif_no ; >> LEFT Join tmplr_agent k On a.agent_no = k.agent_no ; >> LEFT Join tmp50000 l On a.sif_no = l.sif_no ; >> LEFT Join tmplr_policy m On a.sif_no = m.sif_no ; >> LEFT Join tmpfrequency N On a.sif_no = N.sif_no ; >> LEFT Join tmpExp_mod o On a.sif_no = o.sif_no ; >> Into Cursor tmpagg Readwrite >>>>