Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Populating or Creating a Table from Another using SQL

Re: Populating or Creating a Table from Another using SQL

From: Girts Graudins <ggraudins_at_my-deja.com>
Date: Fri, 25 Feb 2000 20:37:09 GMT
Message-ID: <896p5k$7fj$1@nnrp1.deja.com>

> SELECT Caid, Pairs FROM RetardedUsage WHERE Caid = 20 and Pairs < 600;

INSERT INTO Usage (SELECT Caid, Pairs FROM RetardedUsage WHERE Caid = 20 and Pairs < 600);



Girts Graudins
Consulant
The Exeter Group, Inc.
ggraudins_at_hotmail.com
http://www.exetergroup.com/

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Feb 25 2000 - 14:37:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US