Question regarding update [message #7618] |
Wed, 25 June 2003 05:06 |
shawlin
Messages: 25 Registered: April 2003
|
Junior Member |
|
|
Hello
I have a Table TabEmp
Columns are EmpNo, EmpName, DeptName
I have another Tale TabDep
Columns are DepNo, DeptName
I want to execute a Update statement using which I want to update the TabEmp's DeptName
with Equalant DeptNo from TabDep.
Thanks and regards
shawlin
|
|
|
Re: Question regarding update [message #7620 is a reply to message #7618] |
Wed, 25 June 2003 05:56 |
Nalaneelan
Messages: 12 Registered: June 2003
|
Junior Member |
|
|
To be precise, the tabEmp table must contain the DeptNo instead of DeptName, to maintain foreign Key relation.
But with the DeptName it will be difficult to maintain the relation.
Ok, coming to ur question, can u give one example to solve.
|
|
|