Some time we need to delete data form one table on the basis of other table.
e.g.
Table1


EmpId Emp Name Emp Dept
1 Tom Admin
2 Shyam Hr
3 Mall ...