Populating or Creating a Table from Another using SQL

From: Courtney Wright <webmaster_at_hockeytowneinline.com>
Date: Fri, 25 Feb 2000 13:01:42 -0500
Message-ID: <38b6c30d$0$1377_at_news.voyager.net>

[Quoted] [Quoted] I have a table, Usage, that I would like to populate from another table, [Quoted] 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?

[Quoted] 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 [Quoted] end of Usage. This code will be ran from within an Oracle Forms 4.5 trigger [Quoted] by the way...

Please also copy a message to my email cwright_at_tdc-group.com

Thanks,
Courtney Received on Fri Feb 25 2000 - 19:01:42 CET