select dm,xm,xmjx,xb,csrq,whcd,hsgz,zyzg,ThisTerm.bh,qwbb.gz,gzlxb.gzmc
from ThisTerm left join qwbb on ThisTerm.bh=qwbb.bh
left join gzlxb on ThisTerm.gzlx=gzlxb.gzlx
from ThisTerm left join qwbb on ThisTerm.bh=qwbb.bh
left join gzlxb on ThisTerm.gzlx=gzlxb.gzlx
use Access2000