Delete records from One Table based on Record from Another

[somnath_6309]

I want to Delete all records from the Table Named "CustomerWiseRotaryTillerRates" (Given Below) if the State in the State Filed in found in the "Customer_Master" Table (attached Herewith). What will be the correct procedure ?
I followed the steps referred in page no. 67 & 68 in the Book "Microsoft Access 2007 Data Analysis" by Mr. Michel Alexender.

Customer Name	State	Product_Code	Product_Name	Price_perunit
TSI Engineering Indutries (P) Ltd.	Assam	P_05	1500_Rotary_Tiller_220_RPM	Rs. 63,722.00
Kishan Krishi Engineering Works	Jharkhand	P_05	1500_Rotary_Tiller_220_RPM	Rs. 62,997.00
TSI Engineering Indutries (P) Ltd.	Assam	P_06	1750_Rotary_Tiller_220_RPM	Rs. 66,663.00
Shri_Tata_Enterprises	Bihar	P_06	1750_Rotary_Tiller_220_RPM	Rs. 65,683.00

[ranman256]

Use the wizard and build a FIND DUPLICATES QUERY
look at the design, this is the basis of the DELETE query. The IN statement.

You have only 1 table (the one to delete from) in the query, pull down the field that exists in the 'lookup' table
in the field criteria you put another sql statment preceded by the IN command.

(IN select [field] from tLookupTbl)