| Author |
 Topic  |
|
|
poser
Posting Yak Master
124 Posts |
 Posted - 11/12/2010 : 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, KID
Name table has columns: EMPID, LName, Fname
ID table has columns: EMPID, ObjID, KID
Any 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
USA
35017 Posts |
|
|
poser
Posting Yak Master
124 Posts |
Posted - 11/12/2010 : 16:44:10
|
Emp table:
EmpID LName FName ObjID KID
1 Smith Jeff 23 77
2 Craig Bob 25 99
Name Table:
EmpID LName FName
1 Smith Jeff
2 Craig Bob
8 Welk Larry
14 Johns Jim
ID Table:
EmpID ObjID KID
1 23 77
2 25 99
8 27 22
14 44 24
This is the result I want in the Emp table:
EmpID LName FName ObjID KID
1 Smith Jeff 23 77
2 Craig Bob 25 99
8 Welk Larry 27 22
14 Johns Jim 44 24
Thanks for taking the time to look at this...
R/P |
 |
|
|
tkizer
Almighty SQL Goddess
USA
35017 Posts |
|
|
tkizer
Almighty SQL Goddess
USA
35017 Posts |
|
|
poser
Posting Yak Master
124 Posts |
Posted - 11/12/2010 : 19:13:10
|
Thanks Tara for all your help..
R/P |
|
|
|
tkizer
Almighty SQL Goddess
USA
35017 Posts |
|
| |
Topic |
|
Update Table
