[SQL] SQL Query

[beyaNet Consultancy]

Hi,
I am trying to create a query which basically goes along the lines of:

<x-tad-bigger>INSERT INTO tableX ( COL1, COL2 ) VALUES ( x, y ) where COL1 !=x and COL2 !=Y

So, insert a record into tableX where there is not already an existence of COL1 and COL2

Can this be done as I have described or is there a more efficient way to do this?

many thanks

Peter</x-tad-bigger>