SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Update field with a value from another table
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

jbuggs
Starting Member

USA
1 Posts

Posted - 03/28/2013 :  09:29:58  Show Profile  Reply with Quote
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

India
52317 Posts

Posted - 03/28/2013 :  10:33:47  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000