SELECT ryjbqk.xm, ryjbqk.sr, hz.zjhm, zz.zjhm FROM hz;
LEFT JOIN ryjbqk ON ryjbqk.xm=hz.xm;
LEFT JOIN zz ON zz.xm=hz.xm;
WHERE hz.bs2="*";
INTO TABLE a
select distinct top 1200 ryjbqk.xm,ryjbqk.sr,hz.zjhm,zz.zjhm;
from ryjbqk;
join hz on ryjbqk.xm=hz.xm;
join zz on ryjbqk.xm=zz.xm;
where hz.bs2='*';
order by zz.zjhm;
into table a