V
vignesh kumar
Guest
Thank you...! The query looks good and able to get my results. But one concern is in clm100 table you are accumulating by amount but i dont need amount wise in that table i just need to export the no.of records based on clm100.class as below last column. And also in uwm100 table i also need to export the no.of records by poltype whereas we are exporting only the total no.of records in table. The poltype and class are same in two fields. Please export the fields dont need to display it. My excel should be like this, Class Amount (uwm100) No.of record in uwm100 No.of records in clm100 FIA 11033.12 100 50 FFF 52080.6 200 50 ECA 326.26 100 100 EMB 4166.45 50 100 CSV 1423.33 100 100
Continue reading...
Continue reading...