Insert records

[jas2803]

I have two tables, the first table has 2000+ records the other only has approx 500....two columns as "linked" that is they are the same information.... .PK and date...I would like to insert the remaining 1500+ records into the smaller table.

what I need is an if not exist in table2 insert new record using table1 values PK, date

Any Ideas?

[rski]

a- biger table (i is primary key column)
b -smaller table (m is primary key column)

insert into b select * from a where not exists (select * from b where b.m=a.i);

Is it ok?

[jas2803]

Thanks

That was just what I needed, thanks very much!!!!!