Need to set a variable or variables to this select statement
I have this select statement that I have to put into an HTML @query but I get this error:
Only one expression can be specified in the select list when the subquery is not introduced with EXISTS.
select dbo.Users_Master.namereg, dbo.secureToken.usedBy34, dbo.secureToken.serialNBR FROM dbo.Users_Master Left Join dbo.secureToken on dbo.secureToken.usedBy34 = dbo.Users_Master.user34 Where dbo.secureToken.[Enabled] = 'No'