cascade delete from a primary table to its foreign table and then to another primary table

I have an intermediate table (foregin key table) that is used to linked to two primiary tables. I list the tables below.
TableA (PrimaryKeyA, nameA)
TableB (PrimaryKeyB, nameB)
TableIntermed(PriimaryKeyA, PrimaryKeyB) PriimaryKeyA and PrimaryKeyB is the foregin key to its respective table and has a cascade delete on accordingly.
I want this to happen.
When a record in TableA is deleted, the corresponding records in TableIntermed are also deleted. Plus the record in table B that is tied to the deleted record in tablIntermed is also deleted. The first part of delete is handled through cascade delete, but how about the second part delete for table B? Is the trigger the only way to do that?
w

If you want to delete them immediately use triggers but please take care when you impliment triggers on production servers they should be tested throughly.
Alternatively you can scheduled cleanup scirpts normally overnight.

Hi Satya.As Wing said himself, he is aware of the solution you mentioned that deletes related rows in link table when row in tbl_a is deleted. However, he wanted to have row in tbl_B deleted as well when row in table A is deleted.As Frank said, store procedure is the right place to solve that type of business logic.However, that design is odd, it might not be quite correct and there are several questions you need to answer before applying solution:Can corresponding row in tbl_B be linked to another (not deleted) row in tbl_A? If so should also that other row be deleted from tbl_A? and all rows in link table corresponding to another row in tbl_A? and corresponding rows in tabl_B, etc, etc...?If there is always just one corresponding row in tbl_B (linked via link table), then instead of having linked table, better add tbl_B pk column(s) in tbl_A and add foreign key on that column.

Thank you Satya, nice to see you, Frank and Luis still active and helping people.