SQLServer 使用这个语句 compare是一张小表 tzxx是一张大表 select c.*,t.* from compare c inner join tzxx t on c.name=t.name and isnull(c.name,'')='' 但是在ACCESS不能使用 请问怎么修改,才能在ACCESS里面使用语句 与 SQLServer显示出来的数据一样
调试欢乐多
select
c.*,t.*
from
compare c
inner join
tzxx t on c.name=t.name
and
iif(IsNull(c.name),'',c.name)=''
select c.*,t.* from compare c inner join tzxx t on c.name=t.name and c.name is null