Hi,

I need to insert the value 1, 2, 3, 4 to the columns col1, col2, col3, col4 in a table only if the values 3, 4 does not exists in col3, col4 in the table

Something like :

insert into table values(1, 2, 3, 4) where (3, 4) not in select col3, col3 from table

Kindly post the query

Thanks,
MiraJ

declare a unique key on (col3,col4), and let the database do the check for you