28,391
社区成员
发帖
与我相关
我的任务
分享为什么这句在access中不能运行，在sqlserver可以？
为什么这句在access中不能运行，在sqlserver可以？我如何改成在access中运行？
select a.id,a.sendname,a.recename,a.messagesid,a.isread,a.messagestype,a.title,b.username,b.cname,c.ganwei from wjsms as a left join dwuser as b on a.recename=b.username left join zaopin as c on a.messagesid=c.id where a.ntype='单位用户' and c.ganwei like '%安%'
select a.id,a.sendname,a.recename,a.messagesid,a.isread,a.messagestype,a.title,b.username,b.cname,c.ganwei from wjsms as a left join dwuser as b on a.recename=b.username left join zaopin as c on a.messagesid=c.id where a.ntype='单位用户' and c.ganwei like '%安%'
...全文
请发表友善的回复…
发表回复
