Re: Populating or Creating a Table from Another using SQL

insert into Usage (caid, pairs)
select caid, pairs
from retardedusage
where caid = 20
and pairs < 600;

and that's all!

Hth,

Sybrand Bakker, Oracle DBA

Courtney Wright <webmaster_at_hockeytowneinline.com> wrote in message news:38b6c30d$0$1377_at_news.voyager.net...
> I have a table, Usage, that I would like to populate from another table,
> RetardedUsage. RetardedUsage has several columns but I would only like to
> include two in the Usage table. How would I go about doing this using
SQL?
>
> SELECT Caid, Pairs FROM RetardedUsage WHERE Caid = 20 and Pairs < 600;
>
> I would like the results from that query to populate the new table, Usage,
> which has already been create and contains the two columns Caid and Pairs.
>
> Then I would like to query RetardedUsage again and append the results to
the
> end of Usage. This code will be ran from within an Oracle Forms 4.5
trigger
> by the way...
>
> Please also copy a message to my email cwright_at_tdc-group.com
>
> Thanks,
> Courtney
>
>
Received on Fri Feb 25 2000 - 20:32:50 CET