摘要： 1.两表全成一表 select * from (select dwbm,xqid,dwmc,dwbz,xtbz,pxxh from xt_xqdwb union (select xqid,1,xqmc,'0',null,null from xt_xq)) a where a.dwbm'0' and a.xqid='1' and a.dwbz='0' order by a.pxxh 阅读全文