> Many thanks for the replies. > > I knew it must be something simple!! > > Cheers, > R.
> insert into combined_table
> select * from table0
> union
> select * from table1
Note that 'union' will eliminate duplicate rows. Use 'union all' instead
if you don't want this.
__________________________________
Do you Yahoo!?
Yahoo! Mail - now with 250MB free storage. Learn more.
http://info.mail.yahoo.com/mail_250
