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