在ACCESS中
SELECT wzgy.ynbh ,wzgy.gywz,wzgy.gyrq,wzgy.wzffr,jbxx.hzxm,jbxx.zglb,jbxx.zymj,jbxx.xiang,jbxx.cun,jbxx.zu,yjpd.fcf FROM t_wz_wzgy wzgy,t_yn_jbxx jbxx ,t_yn_yjpd yjpd WHERE wzgy.ynbh=jbxx.bh AND jbxx.bh=yjpd.bh
and wzgy.ynbh LIKE '*122201*'
在ADO中
SELECT wzgy.ynbh ,wzgy.gywz,wzgy.gyrq,wzgy.wzffr,jbxx.hzxm,jbxx.zglb,jbxx.zymj,jbxx.xiang,jbxx.cun,jbxx.zu,yjpd.fcf FROM t_wz_wzgy wzgy,t_yn_jbxx jbxx ,t_yn_yjpd yjpd WHERE wzgy.ynbh=jbxx.bh AND jbxx.bh=yjpd.bh AND wzgy.ynbh LIKE '%122201%'
可以,
在ACCESS中
SELECT wzgy.ynbh ,wzgy.gywz,wzgy.gyrq,wzgy.wzffr,jbxx.hzxm,jbxx.zglb,jbxx.zymj,jbxx.xiang,jbxx.cun,jbxx.zu,yjpd.fcf FROM t_wz_wzgy wzgy,t_yn_jbxx jbxx ,t_yn_yjpd yjpd WHERE wzgy.ynbh=jbxx.bh AND jbxx.bh=yjpd.bh
where wzgy.ynbh LIKE '*122201*'
SELECT wzgy.ynbh ,wzgy.gywz,wzgy.gyrq,wzgy.wzffr,jbxx.hzxm,jbxx.zglb,jbxx.zymj,jbxx.xiang,jbxx.cun,jbxx.zu,yjpd.fcf FROM t_wz_wzgy wzgy,t_yn_jbxx jbxx ,t_yn_yjpd yjpd WHERE wzgy.ynbh=jbxx.bh AND jbxx.bh=yjpd.bh AND wzgy.ynbh LIKE '%122201%'
这样为什么查询不出结果来呢?