>From my experince this is not possible. Is there any reason why you can not simply do two inserts following each other? INSERT INTO table1(column1) SELECT column1a FROM table2 WHERE [something] INSERT INTO table1(column2) VALUES(valueFromMemory) (as if you didnt know that already) =D There should be no reason why you couldnt do this as there is nothing that ties the two columns together (that I can see here). Maybe explain a bit more and we might be able to give you more info.
-Nick > 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 > --------------------------------------------------------------------- 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