Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Copying Data
sorry what would be represented by c
"andrewst" <member14183_at_dbforums.com> wrote in message
news:3552561.1067864308_at_dbforums.com...
>
> 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
Received on Mon Nov 03 2003 - 08:09:39 CST