RE: How to insert/update records using SQL?

["Art Tostaine, Jr." <art@xxxxxxxxxxx>]

That looks like what I want.  Thanks!

Art Tostaine, Jr.
CCA, Inc.
Jackson, NJ 08527

-----Original Message-----
From: owner-midrange-l@midrange.com
[mailto:owner-midrange-l@midrange.com]On Behalf Of Buck Calabro
Sent: Thursday, June 07, 2001 1:16 PM
To: MIDRANGE-L@midrange.com
Subject: RE: How to insert/update records using SQL?


> Using a sql statement, how do INSERT or UPDATE the records that already
> exist.

Here's one way:
update armaster set (...) where custid in
  (select custid from armaster)

insert into armaster (...) where custid not in
  (select custid from armaster)

Buck
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---