SQL Query for two tables joining

I have two tables A and B
Table A has two records one for Amitabh and the other for Sharukh
Table B has records of various cars posessed by Amitabh and Sharukh.....

My question is what will be the sql Query in order to delete Sharukh record in both the table... i want to delete Sharukh membership details from Table A & simultaneously delete all the rows of Table B where the cars owner is Sharukh .. Primary key in Table A is an id and in Table B has a mem_id column which is same as that of Table A id ... What is the SQL Query?

Thank you friends..

:thumb:

Please take the time to choose the appropriate forum for your posts. This one has been moved to a more approriate forum.

cascade delete
http://www.techonthenet.com/oracle/foreign_keys/foreign_delete.php