Re: Copying Data

Originally posted by Mumblez

> how can you copy the certain data from one table into another

>

> ie, you create another table but 3 columns used are found in
> others tables,

> how would you populate that table with the contents of the tuples
> from the

> others

> By the way thanks for the help so far

You mean like this?

insert into new_table( a, b )

select t1.a, t2.b

from t1, t2

where t1.c = t2.c;

--
Posted via http://dbforums.com