select [ernetNew].dbo.[tblInstituteDetailAndMain].[DomainName]
CLIENTDOMAINNAME
,
[dbo].[CLIENTREGISTRATION].[DOMAINSTATUS]
,[ernetNew].dbo.[tblInstituteDetailAndMain].[DomainStatus]
from [ernetNew].dbo.[tblInstituteDetailAndMain]
left join [dbo].[CLIENTREGISTRATION] on ltrim(rtrim([dbo].[CLIENTREGISTRATION].CLIENTDOMAINNAME))=rtrim(ltrim([ernetNew].dbo.[tblInstituteDetailAndMain].[DomainName]))

where [dbo].[CLIENTREGISTRATION].[DOMAINSTATUS]='DE'