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.
| Author |
Topic |
|
poser
Posting Yak Master
124 Posts |
 Posted - 2010-11-12 : 15:44:10
|
| Hello, I am trying to update a table....I want to insert into the EMP table from both the Name and ID table.EMPID is PK for all....But the EMP table already has data in it and does not allow duplicates.I have a Emp table I want update from two other tables:Emp table Has columns: EMPID, LName, FName, ObjID, KIDName table has columns: EMPID, LName, FnameID table has columns: EMPID, ObjID, KIDAny easy way to do this?Any and all help would be greatly appreciated....Thanks...SQL Team is the best!R/P |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
poser
Posting Yak Master
124 Posts |
Posted - 2010-11-12 : 16:44:10
|
| Emp table:EmpID LName FName ObjID KID1 Smith Jeff 23 772 Craig Bob 25 99Name Table:EmpID LName FName1 Smith Jeff2 Craig Bob8 Welk Larry14 Johns JimID Table:EmpID ObjID KID1 23 772 25 998 27 2214 44 24This is the result I want in the Emp table: EmpID LName FName ObjID KID1 Smith Jeff 23 772 Craig Bob 25 998 Welk Larry 27 2214 Johns Jim 44 24Thanks for taking the time to look at this...R/P |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
poser
Posting Yak Master
124 Posts |
Posted - 2010-11-12 : 19:13:10
|
| Thanks Tara for all your help..R/P |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
Update Table