SQL代码 提示 不支持连接表达式

[welcome520]

sql = "select PrisonerInto.FileNumber, PrisonerInto.Name,PrisonerInto.Branch,PUser.U_username_S from PrisonerInto left join PUser ON PUser.U_ID_N = PrisonerInto.PoliceID_N and PrisonerInto.Branch = '一'"

执行后提示 "不支持连接表达式" 我用的是access数据库，求怎么解决

[welcome520]

在access环境执行
提示 PrisonerInto.Branch = '一' 这句 不支持连接表达式

[welcome520]

搞定了，原来，应该是 ON PUser.U_ID_N = PrisonerInto.PoliceID_N where PrisonerInto.Branch = '一' 怎么和网上代码不一定，可能Access语句不一样些

[中国风]

SELECT PrisonerInto.FileNumber , PrisonerInto.Name , PrisonerInto.Branch , PUser.U_username_S FROM PrisonerInto LEFT JOIN PUser ON PUser.U_ID_N = PrisonerInto.PoliceID_N WHERE PrisonerInto.Branch = '一'; 这条件只能放在WHERE后，或在SELECT后判断

[中国风]

SELECT PrisonerInto.FileNumber , PrisonerInto.Name , PrisonerInto.Branch , IIF(PrisonerInto.Branch = '一' , PUser.U_username_S ) AS U_username_S FROM PrisonerInto LEFT JOIN PUser ON PUser.U_ID_N = PrisonerInto.PoliceID_N 看看你是要那一个效果，#1满足条件PrisonerInto.Branch = '一' 才会有记录，#2是PrisonerInto.Branch = '一'时U_username_S才显示

[welcome520]

谢谢了.......