This article provides an example to delete records of customer table which are in Gujarat_cust table.
Deletefrom cust where custno in (select custno from Gujarat_cust);