select 'JP 3-1', COUNT(axcrcd) from jemshdp31.ccdcsrp where axdust='V' and AXBTDT<AXADDT AND AXBTDT!=0
UNION
select 'JP 3-2', COUNT(axcrcd) from jemshdp32.ccdcsrp where axdust='V' and AXBTDT<AXADDT AND AXBTDT!=0
UNION
select 'JP 4-1', COUNT(axcrcd) from jemshdp41.ccdcsrp where axdust='V' and AXBTDT<AXADDT AND AXBTDT!=0
UNION
select 'JP 4-2', COUNT(axcrcd) from jemshdp42.ccdcsrp where axdust='V' and AXBTDT<AXADDT AND AXBTDT!=0
UNION
select 'JP 7-1', COUNT(axcrcd) from jemshdp71.ccdcsrp where axdust='V' and AXBTDT<AXADDT AND AXBTDT!=0
UNION
select 'JP 7-2', COUNT(axcrcd) from jemshdp72.ccdcsrp where axdust='V' and AXBTDT<AXADDT AND AXBTDT!=0
UNION
select 'JP 8-1', COUNT(axcrcd) from jemshdp81.ccdcsrp where axdust='V' and AXBTDT<AXADDT AND AXBTDT!=0
UNION
select 'JP 8-2', COUNT(axcrcd) from jemshdp82.ccdcsrp where axdust='V' and AXBTDT<AXADDT AND AXBTDT!=0