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
Avatar of Aleks


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

Link to home
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


That did the trick. Thank you.
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


Its no problem  :) it happens.