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 <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php