Find assets without a certain regkey

[sethm]

I've created the following report that displays assets that contain the regkey 'HKEY_LOCAL_MACHINE\SOFTWARE\VDG'. How would I do the reverse and display systems that do not have that regkey?

Select Top 1000000 tblAssets.AssetID,
tblAssets.Username,
tblAssets.AssetName,
tblAssets.Domain,
tblRegistry.Valuename,
tblRegistry.Value,
tblRegistry.Lastchanged,
tblAssets.Lastseen,
tblRegistry.Regkey
From tblAssets
Inner Join tblRegistry On tblAssets.AssetID = tblRegistry.AssetID
Where tblRegistry.Regkey Like 'HKEY_LOCAL_MACHINE\SOFTWARE\VDG'
Order By tblAssets.AssetName

[sethm]

Currently have it as so and this is giving me 0 results.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblRegistry.Regkey
From tblAssets
Left Join tblRegistry On tblAssets.AssetID = tblRegistry.AssetID
Where tblAssets.AssetID != tblRegistry.AssetID And
tblRegistry.Regkey Not Like 'HKEY_LOCAL_MACHINE\SOFTWARE\VDG'
Order By tblAssets.AssetName

[Esben_D]

Try a left join on tblregistry and add a where condition where tblassets.assetid != tblregistry.assetid