OOPS! Please note correction below! > Here is what I would want to do: > > INSERT INTO administrators (id) values > (SELECT id FROM faculty > WHERE lastName = "Jones") > WHERE ordr = 1;
Sorry! I meant UPDATE, not INSERT! UPDATE administrators SET id = (SELECT id FROM faculty WHERE lastName = "Jones") WHERE ordr = 1; Thanks! Amittai Aviram [EMAIL PROTECTED] This is not spam! See? -- sql.query --------------------------------------------------------------------- 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
