Re: sql insert without duplicate keys

[Sam_L <lennon_s_j@xxxxxxxxxxx>]

Something like this, maybe?  Basically, you have to select only adds 
that don't already exist.

insert into myfile
   (select * from myadds a
    where not exists
      (select 1 from myfile f
       where  f.key = a.k)
   )

Sam

On 6/15/2015 9:46 AM, Jack Tucky wrote:
> Thank you.  I have another question.
>
> This delete statement works, how can I change it to insert records in
> invdww/locctn00.  I need to join locctn00 in the select statement somehow.
>
> Thanks
>
> delete
> from invdww/locctn00 lc where exists
> (select * from  invdww/locplt00 lp
> where shp=50113 and lp.rid=lc.rid and lp.plt=lc.plt  )
>
> On Sun, Jun 14, 2015 at 5:50 PM, Glenn Gundermann <
> glenn.gundermann@xxxxxxxxx> wrote:
>
> > Use the MERGE statement.
> >
> > -----Original Message-----
> > From: Jack Tucky <jacktucky@xxxxxxxxx>
> > Sender: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>Date: Sun, 14 Jun
> > 2015 16:32:48
> > To: Midrange Systems Technical Discussion<midrange-l@xxxxxxxxxxxx>
> > Reply-To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> > Subject: sql insert without duplicate keys
> >
> > I am running a statement like this for multiple files.
> >
> > How can I eliminate copying records that already exist in the destination
> > file?  There are additional key fields besides SHP.
> >
> >
> >
> > INSERT INTO INVTO/skusum
> > SELECT * FROM INVFROM/skusum  WHERE shp = 12345
> >
> > Thanks, Jack
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/midrange-l.
> >
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/midrange-l.