Shell Programming and Scripting

Hi,

Table1
======
Code1
Field1

Table2
======
Code1
Field1

Would anyone be able to help me know what's the best sql command to delete the entry in Table1 if its Code1-Field1 combination is already existing in Table2.

I used this one -
delete from Table1 where Code1 in (select Code1 from Table2)
and Field1 in (select Field1 from Table2)

But this one will delete the entry even if its not exactly the Code1-Field1 combo, as long as both Code1 matches and Field1 exists in any of the rows in Table2 right?

Thanks in advance.

delete from table1 where code1||field1 in (select code1||field1 from table2);
try this