Select zlxmid,zlxmjc,zlxmbh,lbbz00,gdxmbz,fbzxbz,dw0000,a.wbsm00,a.pysm00,a.lbbh00,a.zhxmbz,a.jkbh01,a.jytzbh,
lbmc00,jgdw00,ckz000,xxms00,a.qyrq00,a.tzrq00,a.bz0000,sfyxsq,dlkszx,dlbqzx,bqsfbz,A.ZXKS00 BMBH00,BBid00,BQDYBZ,zyzbid,jclbid, A.SQDID0
 from BM_ZLZD00 a,bm_zlxmlb b
 where a.lbbh00=b.lbbh00 and zlxmbh like '%'
 and sfmbxm='1' and zxks00=1511
 and Zlxmid>=100 order by zlxmbh