Hi all
I have a basic sql situation that is bugging me. I could not find the
answer anywhere that i looked, and i could not find a newsgroups
specialized in sql to ask this question.
If this is not the right place to ask, please be gentle! and point me in
the right direction.
Please note that this is a real situation i am running into, but i
simplified it to this example. So this is not a homework (if you were
wondering!)

here we go...
i have four tables T1, T2, T3 and T4 related to each other in a one to
many relation (one in T1 to many in T2. one in T2 to many in T3, and one
 in T3 to many in T4).

how would i delete all rows in T4 that are related (or trace back) to a
specific record in T1.

let's assume this structure for simplicity:

TABLE T1
ID    (PK)

TABLE T2
ID    (PK)
T1_ID (FK)

TABLE T3
ID    (PK)
T2_ID (FK)

TABLE T4
ID    (PK)
T3_ID (FK)

so now i want to delete all rows in table T4 that trace back to a
specific row in T1.

Thanks for any help.
hilz.