G
Guest
I have 2 tables: 'tblAssetCatLinkBackup012501' and 'tblAssetCatLink'. Both
tables have a field called 'asset'. I want to see which assets in the
'tblAssetCatLinkBackup012501' table are NOT in the 'tblAssetCatLink' table.
My query is below, but the 'NOT IN' in the WHERE clause is not working. Am I
writing this correctly?
Thanks for any help.
select asset
from tblAssetCatLinkBackup012501
where asset NOT IN (select asset from tblAssetCatLink);
tables have a field called 'asset'. I want to see which assets in the
'tblAssetCatLinkBackup012501' table are NOT in the 'tblAssetCatLink' table.
My query is below, but the 'NOT IN' in the WHERE clause is not working. Am I
writing this correctly?
Thanks for any help.
select asset
from tblAssetCatLinkBackup012501
where asset NOT IN (select asset from tblAssetCatLink);