How to get all the rows in the third table, accessing the first through transit (foreign keys)?

Question

Django

There is a model like:

class A( models.Model ):
  field = models.CharField()

class B( models.Model ):
  a = models.ForeignKey( A, on_delete = models.CASCADE, related_name = 'a_b_a' )

class C( models.Model ):
  b = models.ForeignKey( B, on_delete = models.CASCADE, related_name = 'b_c_b' )

Referring to table "A": It is
c_all = A.objects.all()
necessary to add a query so that all rows from table "C" are pulled out. Table 'B' can have multiple rows related to 'A', just as table 'C' can have multiple rows related to any row in 'B'.

Answer 1

c_all = C.objects.filter(b__a_id=123)