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