I have two tables both are having some data now what i want i want remove some duplicate data in column as for example

Table1 Table2
----------------------- ------------------------------------
Date | DocNumber | Qty Date | ExternNumber | Qty



Now i want remove rows where DocNumber and ExternNumber are same. It may be happen that DocNumber and ExternNumber having same value may be not come in same row.