Select [ChamA] from [dbo].[TableA] where [dbo].[TableA].[ChamA] NOT IN (Select [ChamA] FROM [dbo].[TableB])