select ac.name from ac inner join ab on ac.id=ab.ac_idinner join aa on aa.ab_id=ab.idwhere aa.abid=....
