Re: Best way to load differential rows on table with composite key

Kevin wrote: > > Sorry I wasn't very specific, again attribute to Mon morning, I'm trying to > do this with SQL. > Thanks again! > Kevin > > Kevin wrote in message <6uo7p1$b46$1@news1-alterdial.uu.net>... > >Hey! > >I'm trying to load the rows from table a that are not in table b, into > table > >b. > >The table has a composite key and has a large number of rows. I'm sure this > >is a no brainer, but seeing as it's Mon morning I think I qualify. > >Thanks for any help! > >Kevin Hi Kevin I'm new to informix, but the following works under most other platforms I've seen insert into b Select * From a Where Not Exist (Select c.key1, c.key2 From b c Where c.key1 = a.key1 and c.key2 = a.key2) HTH Regards Clint.