Query: Select GLAccGLCaption with missing ClientType

Select * from [GLAccGLCaption] LEFT JOIN [ClientType] ON ([GLAccGLCaption].[TableId] = [ClientType].[Id] and [GLAccGLCaption].[DBId] = [ClientType].[DBId]) where [GLAccGLCaption].[TableName] = 'ClientType' and [ClientType].[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 [ClientType]
ON ([GLAccGLCaption].[TableId] = [ClientType].[Id] and [GLAccGLCaption].[DBId] = [ClientType].[DBId])
where [GLAccGLCaption].[TableName] = 'ClientType'
and [ClientType].[Id] Is Null)