select door.policeid, door.doorid, jwh.jwhname, history.czzt
from door, jwh, history
where left(door.doorid,2)=jwh.duanid and history.zdz=door.policeid+'|'+door.doorid
from door, jwh, history
where left(door.doorid,2)=jwh.duanid and history.zdz=door.policeid+'|'+door.doorid
这个是干什么的?
如果是模糊查询就要改成
door.doorid like jwh.duanid+'%'
from door, jwh, history
where door.doorid like jwh.duanid + '%' and history.zdz=door.policeid+'|'+door.doorid
door.policeid=left(history,6) and door.doorid=right(history,5)
但right方法好像不是很正常,有部分数据取不到,不知道是什么原因。
weixy知道的话,再帮我一下好吗。谢谢先!
应是door.policeid=left(history.zdz,6) and door.doorid=right(history.zdz,5)还有history.zdz右边是否有空格;(右边有空格用:Rtrim(right(history.zdz,5)))door.policeid是否一定是6位;door.doorid是否一定是5位;