[Answered ]-Django perform a join on multiple tables

No need for .select_related(…) or .prefetch_related(…). You can filter with:

c_list = C.objects.filter(b__a_id__in=table_a_ids)