🚀 go-pugleaf

Hi Donato!
Try
Insert Into table1
         Select *
            from table2 a
          where not Exists(Select 1
                                      From table1 b
                                     Where b.cod = a.cod
                                         And b.year = a.year
                                         And b.subcod = a.subcod);

Bye

FBrador


"Donato Verrastro" <donato.verrastro@libero.it> wrote in message
news:3de74a9e@newsgroups.borland.com...
> I have a problem to write a query. Can you help me?
> I have a two table:
> CREATE TABLE1 (COD NUMBER(10,0),
>                                YEAR NUMBER(10,0),
>                                SUBCOD NUMBER(10,0),
>                                ..,
>                                PRIMARY KEY(COD,YEAR,SUBCOD));
> and table2
> CREATE TABLE2 (COD NUMBER(10,0),
>                                 YEAR NUMBER(10,0),
>                                 SUBCOD NUMBER(10,0),
>                                 ..,
>                                 PRIMARY KEY(COD,YEAR,SUBCOD));
> I want to insert in TABLE1 all record of TABLE2 that are not present in
> TABLE1.
> How can I do this query?
> I have write the following query but i think that it isn't correct.
> INSERT INTO TABLE1
>   SELECT .... FROM TABLE2
>   WHERE COD||'-'||YEAR||'-'||SUBCOD NOT IN (SELECT
> COD||'-'||YEAR||'-'||SUBCOD FROM TABLE2);
> Thank you in advance
> Donato Verrastro
>
>
>
>