select br.batchkey, count(rj.id) as ratejobcreated, (select COUNT(ID) from RATEJOB inner join batch_ratejob on batch_ratejob.ratejobkey = ratejob.id where batch_ratejob.batchkey = br.batchkey and completedflag = 1) Farhan Iqbal (3:28:06 PM): as ratejobcompleted, u.loginname, COUNT(rp.id) as shipment_count from batch_ratejob br inner join ratejob rj on br.ratejobkey = rj.id inner join users u on rj.userkey = u.id inner join batch b on br.batchkey = b.id inner join rateprocess rp on rp.batchkey = b.id group by br.batchkey, u.loginname
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)