cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
AlexMZetec
Engaged Sweeper II
Hello all!

I have a report that show me computer list with their tblTPM.SpecVersion.
But the report doesn't show me computers with NO tblTPM.SpecVersion. It only show computers with a tblTPM.SpecVersion.
I would like to see all computers with or without tblTPM.SpecVersion.
How do I tell to show all even if empty?

In advance thx for your help!


Select Top 1000000 tsysAssetTypes.AssetTypeIcon16 As icon,
tblAssets.AssetName,
Case
When tblDiskPartition.Bootable = 'True' And tblDiskPartition.Type =
'Installable File System' Then 'Legacy'
When tblDiskPartition.Bootable = 'True' And tblDiskPartition.Type <>
'Installable File System' Then 'UEFI'
End As BiosType,
Case
When tblEncryptableVolume.ProtectionStatus = 0 Then 'OFF'
When tblEncryptableVolume.ProtectionStatus = 1 Then 'ON'
Else 'UNKNOWN'
End As ProtectionStatus,
tblEncryptableVolume.DriveLetter,
tsysOS.OSname As OS,
tblAssets.SP As SP,
tblAssets.Username,
tblAssetCustom.State,
tblTPM.SpecVersion
From tblEncryptableVolume
Inner Join tblAssets On tblEncryptableVolume.AssetId = tblAssets.AssetID
Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblDiskPartition On tblAssets.AssetID = tblDiskPartition.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblTPM On tblAssets.AssetID = tblTPM.AssetId
Where (tblAssets.AssetName Like 'QC-%' Or tblAssets.AssetName Like 'FR-%') And
Case
When tblDiskPartition.Bootable = 'True' And tblDiskPartition.Type =
'Installable File System' Then 'Legacy'
When tblDiskPartition.Bootable = 'True' And tblDiskPartition.Type <>
'Installable File System' Then 'UEFI'
End Is Not Null And tblEncryptableVolume.DriveLetter = 'C:' And
tblAssetCustom.State = 1
Order By tblAssets.AssetName
1 ACCEPTED SOLUTION
RCorbeil
Honored Sweeper II
By definition, the INNER JOIN against tblTPM is saying "only show me records where there exists a corresponding entry in the tblTPM table". Try changing it to a LEFT JOIN, "show me all records including, if there happens to exist anything there, values from tblTPM".

View solution in original post

2 REPLIES 2
AlexMZetec
Engaged Sweeper II
It works!
Wonderful!

1000 thank you!


RCorbeil
Honored Sweeper II
By definition, the INNER JOIN against tblTPM is saying "only show me records where there exists a corresponding entry in the tblTPM table". Try changing it to a LEFT JOIN, "show me all records including, if there happens to exist anything there, values from tblTPM".