You can run select into cursor and than add records to a table. In VFP8 you'll be able to do that in one command INSERT INTO SELECT FROM.

select * from temp into CURSOR crsCatalog
SELECT catalog
APPEND FROM ( DBF("crsCatalog"))
* or if you want to add all records from 'temp'
APPEND FROM ( DBF("temp"))

>hello all
>
>how to add the result of a query into a database where in the table already exist in the database.
>
>eg select * from temp into table catalog database mydbc gives a error message
>
>catalog.dbf already exists as part of a database.
>
>txs