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