insert into another table with 2 primary keys.

Hi,

I have two table t1(with two primary keys c1 and c2) and t2

t1
c1 c2 c3 c4
2 5 1 0
2 4 1 0
5 2 0 1
4 2 0 1
2 2 1 1

t2
cc1 cc2 cc3 cc4

2      4     1    -1
2      3     0     1
2      5     0     1
2      2     0     1

I want to insert t2's data into t1 and the t2(2,4,1,-1) should not be inserted into t1 table and so on... Does anyone know how to do it? Any helps will be appricated.

Thanks. Received on Tue Sep 22 1998 - 17:30:03 CDT