Select * from [Options] where
convert(varchar, [Options].[DBId]) + '-' + [Options].[Variable] + '-' + [Options].[OrgTable] + '-' + [Options].[OrgTable] + '-' + convert(varchar, [Options].[FieldId])
in (Select convert(varchar, [Options].[DBId]) + '-' + [Options].[Variable] + '-' + [Options].[OrgTable] + '-' + [Options].[OrgTable] + '-' + convert(varchar, [Options].[FieldId]) from
([Options] Left Join [GLAccount]
ON [Options].[ReferenceId] = [GLAccount].[Id] and [Options].[DBId] = [GLAccount].[DBId])
where Not [Options].[ReferenceId] = 0 and [GLAccount].[Id] is null)