-----Original Message----- From: Norris, Joseph Sent: Wednesday, January 22, 2003 10:56 AM To: Mysql_List (E-mail) Subject: question about update sql
Hello, I have the following in my SQL: update call_center set call_center.who_for_id = activeemployees.hr_emp_no where call_center.who_for_id = activeemployees.id; This is something I think that I should be able to do, but I get an error. Is there a way to do what I am trying to do here? Thanks to all. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php