Set SR logon in DMW Databse

SELECT TOP (1000) sr.[UserLogin] ,[SrUserId] ,[IsDeferredSrEnabled] ,[IsFrontendSrEnabled] ,[SrLanguage] ,ad.Email ,'Update SpeechRecognitionUser set sruserid = ''' + ad.email + ''' where userlogin = ''' + u.userlogin + '''' ,u.LastUpdated ,u.UpdatedBy FROM [WinscribeText_Prod].[dbo].[SpeechRecognitionUser] sr inner join [user] u on u.UserLogin = sr.UserLogin inner join [address] ad on ad.LicenseNumber = u.LicenseNumber where IsFrontendSrEnabled = 1 AND [SrUserId]!=[Email] Only returns user where SR ID and email don't match Produces an update statement to set logon correctly