Ulises,

Erik showed you how to to this. My question is, do you really need a third table? Would the CURSOR from the SELECT do?

You can also SELECT ... INTO TABLE ___ DATABASE MyDatabase but the table can't already be part of the database or you will have an error.





>I have a query that gathers information from two different tables. How can I append or insert or somehow use the results of the query to fill up a new 3rd table?. Please be as specific as possible.
>Thank you for your time.
>Ulises.