select * from Mb_infoA where partpn='',
union all select * from Mb_infoB where partpn=''
union all select * from Mb_infoC where partpn=''......
union all select * from Mb_infoB where partpn=''
union all select * from Mb_infoC where partpn=''......
select * from Mb_infoA
union all select * from Mb_infoB
union all select * from Mb_infoC
union all select * from Mb_infoD
union all select * from Mb_infoE
) A where A.partpn=''
select mo_no, partpn as pn,model,vendorcode as vendor,datecode,sum(partqty) AS partqty,station from (
select mo_no, partpn ,model,vendorcode ,datecode,sum(partqty) ,station from Mb_infoA
union select mo_no, partpn ,model,vendorcode ,datecode,sum(partqty) ,station from Mb_infoB
union select mo_no, partpn ,model,vendorcode ,datecode,sum(partqty) ,station from Mb_infoC
union select mo_no, partpn ,model,vendorcode ,datecode,sum(partqty) ,station from Mb_infoE ) A
where a.partpn like '10-50773-00'
GROUP BY mo_no, partpn,model,vendorcode,datecode,station
是不是这里呀?