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 |
|
Sambhav
Starting Member
31 Posts |
 Posted - 2007-07-02 : 15:27:22
|
HiI have to update the incidents table.The initiator and initdept are two corresponding columns whoes value I have to get from another table Employee where (initiator means Empname and initdept means title)if i just do select Empname,title from employee it gives me correct output while select initiator,initdept from incidentsIt gives the initiator correct but instead of giving the initdept it gives output as initaiator the out put is given below initiator initdeptJeff C. Taylor Jeff C. Taylor Randy S. Jonas Randy S. Jonas Mike lewis Mike lewis it should give the out put like initiator initdeptJeff C. Taylor Software Engg Randy S. Jonas TesterI hope you got my question! now I hav to update incidents table such that it should give initiator as well as its corrosponding initdept thanks sambhav jain |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-07-02 : 16:17:19
|
| Since you've now posted this same thing in your other thread, I'm going to lock this topic.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
Update 2 corresponding columns