Yes. You can use INSERT INTO <table> select from ...... Regards,
> All, > > Is this query possible to do: > > I am going to select an id from a table > > SELECT order_id FROM orders WHERE order_start = 1324 > > I will then use the order_id from this query and insert it as well as > some others values I have into another table. > > So in summary, I want to perform a SELECT and INSERT in the same > database query. > > Can I do it? > > If this matters, I will be doing this in 2 different applications. 1 > database is MySQL, and the other is MS Access. > > -jonathan > > --------------------------------------------------------------------- > 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 <mysql-unsubscribe- [EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Yours, KH Chiu C&A Computer Consultants Ltd. Tel: 3104 2070 Fax: 3010 0896 Email: [EMAIL PROTECTED] Website: www.caconsultant.com --------------------------------------------------------------------- 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