You cannot double join, analytics module exists and can multi-level joins. Your only other option in this scenario is the start at Sales Order and go one direction both ways