Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Update field with a value from another table

Author  Topic 

jbuggs
Starting Member

1 Post

Posted - 2013-03-28 : 09:29:58
I have two tables (Opportunity and Project). Basically, I just want to update the opportunity name field based on the project name field where the project code = X

The opportunity table does not have any exact matches when comparing the project table. Thus, I am going to specify the update based on the project code.

Thanks in Advance!

James Bunn

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-03-28 : 10:33:47
so does that mean entire oppurtunity table name fields will have same value? Or do you've multiple records in project table with code='X'

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -