select * from jemshdp31.CCBFNCP where mbCNCD='WARUP2'
UNION
select * from jemshdp32.CCBFNCP where mbCNCD='WARUP2'
UNION
select * from jemshdp41.CCBFNCP where mbCNCD='WARUP2'
UNION
select * from jemshdp42.CCBFNCP where mbCNCD='WARUP2'
UNION
select * from jemshdp71.CCBFNCP where mbCNCD='WARUP2'
UNION
select * from jemshdp72.CCBFNCP where mbCNCD='WARUP2'
UNION
select * from jemshdp81.CCBFNCP where mbCNCD='WARUP2'
UNION
select * from jemshdp82.CCBFNCP where mbCNCD='WARUP2'