Appending data to a table

How can I append data to a table without having to know
the columns in the from table. For example in XBASE I
was able to "use" a table and then "append from" another
and XBASE would match the field for me. If the used
table had 10 fields in common with a append from table
then only those 10 fields would be copied.

Thanks.

There is automatic match of fields in sql, however what you can do is

insert into tbl_inserttable
select * from appendtable

where the tbl_insert must have the same structure as the table where you
want to append from

--
Regards,

Dandy Weyn
MCSE, MCSA, MCDBA, MCT

http://www.dandyman.net

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode test 33Switch to Hybrid Mode Switch to Threaded Mode

1 10th July 05:19 alex campos External User Posts: 1	Appending data to a table How can I append data to a table without having to know the columns in the from table. For example in XBASE I was able to "use" a table and then "append from" another and XBASE would match the field for me. If the used table had 10 fields in common with a append from table then only those 10 fields would be copied. Thanks.

2 10th July 05:19 dandy weyn External User Posts: 1	Appending data to a table There is automatic match of fields in sql, however what you can do is insert into tbl_inserttable select * from appendtable where the tbl_insert must have the same structure as the table where you want to append from -- Regards, Dandy Weyn MCSE, MCSA, MCDBA, MCT http://www.dandyman.net