<div>
You should made a join on the update sentence. Please see this link: <a href="http://stackoverflow.com/questions/1262786/mysql-update-query-based-on-select-query" rel="ugc">http://stackoverflow.com/questions/1262786/mysql-update-query-based-on-select-query</a><br />
<br />
Hope it helps. Regards.
</div>


You should made a join on the update sentence. Please see this link: http://stackoverflow.com/questions/1262786/mysql-update-query-based-on-select-query [http://stackoverflow.com/questions/1262786/mysql-update-query-based-on-select-query]

Hope it helps. Regards.

<div>
Perfect, thanks!<br />
<br />
RBS
</div>


<div>
Thanks for the grade. &nbsp;Good luck with your project. &nbsp;-Jim
</div>


Thanks for the grade.  Good luck with your project.  -Jim

<div>
<div class="content wysiwyg-content">
Hi:<br />
<br />
I have a table aspnet_Users with columns UserId (uniqueidentifier) and UserName varchar(256). &nbsp;<br />
<br />
What I would like to do is copy all the UserName values from this table to my UserProfiles table that &nbsp;also has also has UserId and UserName columns so that the UserName values match the UserId values in the new table - i.e. &nbsp;username jsmith in record with UserId=xxyx in aspnet_Users is copied to the record in UserProfiles that has a UserId of xxyx<br />
<br />
Any help greatly appreciated.<br />
<br />
RBS
</div>
</div>


Hi:

I have a table aspnet_Users with columns UserId (uniqueidentifier) and UserName varchar(256).  

What I would like to do is copy all the UserName values from this table to my UserProfiles table that  also has also has UserId and UserName columns so that the UserName values match the UserId values in the new table - i.e.  username jsmith in record with UserId=xxyx in aspnet_Users is copied to the record in UserProfiles that has a UserId of xxyx

Any help greatly appreciated.

RBS

Copying values related to one column in one table to another with same values of second column

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.