-
User is issuing below query.
create table wilson2a
as select cpolicypfx, cpolicyno, criskstate, cpecode, nclaimoffc, nclaimno, nclaimsuff,
nrtline, NOCCURDATE, NCMADEDATE, CMINORCO, cmajorline,CBORISCODE, CFILLER1, creinsco, caccountid,
sum(nvl(npayment,0)) npayment,sum(nvl(nreserve,0)) nreserve,sum(nvl(npaidtodat,0)) npaidtodat,
sum(nvl(nopencount,0)) nopencount, sum(nvl(ncwpcount,0)) ncwpcount,
sum(nvl(ncnpcount,0)) ncnpcount
from homesupp a, homemain b where cpolicyno in
('1951726','5969327','9086977','9130806','9131869','9170162','9170171','9170223','9195863','9196064' ,
'9196103','9259702','9259743','9259750','9259783','9259786','9259795','9259859','9259865','9259926',
'9259965','9260213','9260516','9260517','9260521','9260529','9260563','9260570','9260577','9260700',
'9260719','9260762','9260770','9260771','9260810','9260816','9260841','9260853','9260857','9260886',
'C148574','C148579','C148581','C148582','C148588','C148596','C148597','C148601','C148611','C148642')
and a.nrecnum=b.nrecnum
group by cpolicypfx, cpolicyno, criskstate, cpecode, nclaimoffc, nclaimno, nclaimsuff,
nrtline, NOCCURDATE, NCMADEDATE, CMINORCO, cmajorline, CBORISCODE, CFILLER1, creinsco, caccountid;
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|