単にこういう事でないの?

select * from
A join B on A.id = B.id
join C on B.name = C.name;

select * from A, B, C
where
A.id = B.id and B.name = C.name;