add a record to a table

Hi everybody I have a question. This is what I am trying to do. I pulled data from three different tables now I want to be able to save and add data in one table. That table will now be holding the information. Any help will be appreciated

Probably the easiest way is to create a temporary table with the data you select from the 3 source tables. Once you have all of the data in place you can simply do an insert into the new table by selecting it from the temp table. It may be easier to create a regular table for the temporary data depending on the database software you are using as each vendor manages temp tables differently...

the sytax for gathering/moving the data will be something like: (depending on vendor)

insert into table table_name
select col1, col2,... from source_table;