[RBASE-L] - RE: Union Select

[Jan Barley]

Dennis,
Here it is:

cre temp vie vduesact (DMonth,DuesPer,TIamt,TPAmt,TCAmt) as sel 
idate,(((iyr4(idate))*100)+(imon(idate))),+
  0,(sum(iamt)),0 from vcie where idate >= (.vdrpb) and acctid = '401' group by 
idate +
union sel pdate,(((iyr4(pdate))*100)+(imon(pdate))),+
  (sum(pamt)),0,0 from vcie where pdate >= (.vdrpb) and acctid = '401' group by 
pdate +
union sel pdate,(((iyr4(pdate))*100)+(imon(pdate))),+
  0,0,(sum(iamt)) from vcie where pdate >= (.vdrpb) and acctid = '401' and 
payway = 'cancel' group by pdate

Thanks!

Jan