Hi ,

I want to delete the records from table2 which are in the table1

there is a PK - Family ID.. and i have totally 30 Columns in each table

2 tables are same ..

Here is the Script i wrote

DELETE FROM table2

WHERE ([Family ID] IN

(SELECT [Family ID]FROM table1))

untill now working fine ...

But .. The Script i am looking for is ..

I want to delete the records from table2 which are in table1 ..mean matching all the columns

So .. i updated script like

Delete from table2

where exists (select * from table1)

Just want to know whether it is Correct or not ..please correct me if this is wrong Please ...