I am tryint to update a table and I am having to ref. another table. I keep getting an error. How do I do this ? The statement that I am using is :<br><br><br>UPDATE Ejob<br>SET<br>EjSupervisor = EbLastName + "," + " " + EbFirstName<br>WHERE <br>EjSupervisorFlxIDEb = EbFlxID
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
HELP !!!! Need to update table with ref. to another table.
- Thread starter Neozero
- Start date
You have not used from clause to indicate your ref table.<br><br>Here is an example. I assumed that Ebase is the ref table containing EbFlxId.<br><br><br><br>UPDATE Ejob<br>SET<br>EjSupervisor = EbLastName + "," + " " + EbFirstName<br>FROM Ejob, Ebase<br>WHERE <br>EjSupervisorFlxIDEb = EbFlxID <br><br><br>Regards<br><br>Subramanian K
- Status
Similar threads
- Locked
- Question
- Locked
- Question