有A、B、C三张表，A表的主键是B表的外键，B表的主键是C表的外键，怎么根据A表的主键删除C表的数据

Answer 1

DELETE FROM C WHERE C.ID IN
(
SELECT B.ID FROM B WHERE B.ID IN (SELECT A.ID FROM A WHERE ID=AID)
)

Answer 2

DELETE FROM C WHERE C.BID IN ( SELECT B.ID FROM B WHERE B.AID= AID )