You might want to try the SQL insert into sometable select * from someothertable where something = somethingelse "Gerardo Rojas" <grojas@xxxxxxxxxxxxxxxx> schrieb im Newsbeitrag news:F0EDCD6B96C14741A2F6B0BE6EB7D9CF6D7250@xxxxxxxxxxxxxxxxxxxxxxxxxxx I have a valid result set from running a simple query. Is there a way of inserting this into an existing table or creating a new table with the result set? All ideas are welcome! MSSQL Server 2000 PHP 4.3.4 Windows 2000 pro IIS 5.0 -- Gerardo S. Rojas mailto: grojas@xxxxxxxxxxxxxxxx -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php