Hi, I am working with joins method, I have 2 tables namely food and foodtypes. For eg, Foods type_id id Foodtypes 1. chocolate 1 1. Bakery 2. Biscuit 1 2. Fruit 3. Banana 2 4. Apple 2 Now if want to delete both chocolate and Biscuit in table Food. How my table will be updated?. I need my table to be updated like this. Foods type_id id Foodtypes 1. Banana 1 1 Fruit 2. Apple 1 Can anyone please explain how this can be achived. Thankyou very much. Sreedhar