I have an Access database with 2 tables开发者_JS百科 and I would like a query which lists items which are in one table but not the other.
select a.*
from TableA as a
left join TableB as b
on a.Col = b.Col
where isNull(b.Col)
I have an Access database with 2 tables开发者_JS百科 and I would like a query which lists items which are in one table but not the other.
select a.*
from TableA as a
left join TableB as b
on a.Col = b.Col
where isNull(b.Col)
精彩评论