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@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 - 12:01:42 CST