Query: Select GLAccGLCaption with missing SupplierType

Select * from [GLAccGLCaption] LEFT JOIN [SupplierType] ON
([GLAccGLCaption].[TableId] = [SupplierType].[Id] and [GLAccGLCaption].[DBId] = [SupplierType].[DBId])
where [GLAccGLCaption].[TableName] = 'SupplierType' and [SupplierType].[Id] Is Null

Select * from [GLAccGLCaption]
where convert(varchar(50), [GLAccGLCaption].[DBId])
+ '-' + convert(varchar(50), [GLAccGLCaption].[GLAccountId])
+ '-' + convert(varchar(50), [GLAccGLCaption].[TableName])
+ '-' + convert(varchar(50), [GLAccGLCaption].[TableId])
+ '-' + convert(varchar(50), [GLAccGLCaption].[GLCaptionPlanId])
+ '-' + convert(varchar(50), [GLAccGLCaption].[GLCaptionId])
+ '-' + convert(varchar(50), [GLAccGLCaption].[DGLCaptionId])
+ '-' + convert(varchar(50), [GLAccGLCaption].[CGLCaptionId])
in (Select
convert(varchar(50), [GLAccGLCaption].[DBId])
+ '-' + convert(varchar(50), [GLAccGLCaption].[GLAccountId])
+ '-' + convert(varchar(50), [GLAccGLCaption].[TableName])
+ '-' + convert(varchar(50), [GLAccGLCaption].[TableId])
+ '-' + convert(varchar(50), [GLAccGLCaption].[GLCaptionPlanId])
+ '-' + convert(varchar(50), [GLAccGLCaption].[GLCaptionId])
+ '-' + convert(varchar(50), [GLAccGLCaption].[DGLCaptionId])
+ '-' + convert(varchar(50), [GLAccGLCaption].[CGLCaptionId])
from
[GLAccGLCaption] LEFT JOIN [SupplierType]
ON ([GLAccGLCaption].[TableId] = [SupplierType].[Id] and [GLAccGLCaption].[DBId] = [SupplierType].[DBId])
where [GLAccGLCaption].[TableName] = 'SupplierType'
and [SupplierType].[Id] Is Null)