Link to home
Start Free TrialLog in
Avatar of Aleks
AleksFlag for United States of America

asked on

Update the value of table B with value of table A tables inner join

i have table A:  This is how I query it

SELECT ParamId ,
       ParamFirmId ,
       ParamUserId ,
       ParamName ,
       ParamValue FROM dbo.ParametersUsers
WHERE ParamName = qnrsview

Open in new window


Table B is called "Userlogin"

I need to update the field "qnrsview" from the users table with the value of ParametersUsers  table
ParametersUsers.ParamUserId  = Userslogin.userid

I hope I made some sense.  Userlogin.qnrsview should end up with the same value as ParametersUsers value where ParametersUsers  .ParamUserId = Userlogin.Userid
Avatar of Wayne Barron
Wayne Barron
Flag of United States of America image

ASP Classic
ASP.NET
Avatar of Aleks

ASKER

The update should be done by running a query. I am using  SQL 2012
ASKER CERTIFIED SOLUTION
Avatar of Nakul Vachhrajani
Nakul Vachhrajani
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Aleks

ASKER

That did the trick. Thank you.
@amucinobluedot
Glad that you got this resolved.
To be honest, I had been working with a lot of ASP.NET code on the day this thread came in.
And I was not thinking SQL Server, I was thinking. ASP.

Sorry, lost my train of thought on this one.
Avatar of Aleks

ASKER

Its no problem  :) it happens.