I have to do an insert and need to nest a select inside. I have tons of documentation on a very simple version of this, however my requirements are one step beyond that. Here is what I'd like to do in MySQL:
insert into table1 (column1, column2) values (select column1a from table2 where [something], valueFromMemory) If you'll notice, I want one column from a select and one column outside the select. Is this possible in MySQL? All the documentation I've read about MySQL says it can't be done. Thank you in advance! Mark --------------------------------------------------------------------- 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