Re: Populating or Creating a Table from Another using SQL

From: BLANC Philippe <blancphi_at_club-internet.fr>
Date: Sun, 27 Feb 2000 20:27:49 +0100
Message-ID: <951680857.22481982_at_news.club-internet.fr>


Le ven, 25 fév 2000, Courtney Wright a écrit :
>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
You can do a select into Received on Sun Feb 27 2000 - 20:27:49 CET

Original text of this message