--- "Kristen G. Thorson" <kthorson@xxxxxxxxxxxxxxxxxxxxxx> wrote: > Try > > INSERT INTO Orders (SELECT '678',Cust_ID,Item_No,No_ordered FROM > Last_Order WHERE Cust_ID = '678') Thanks that nailed it. You rock. -k. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
