Django: outputting data from dependent tables?

Question

Django

Where it is possible to esteem about an output of the data from the connected tables? Implementation of pivot tables, etc. Examples, books. It is not entirely clear from the documentation, for example, how to implement such a sql query:

select * from mainapp_dairy, mainapp_auto, mainapp_department 
where mainapp_dairy.auto_id=mainapp_auto.id AND mainapp_auto.department_id=mainapp_department.id

Answer 1

I don't know what might be incomprehensible here https://docs.djangoproject.com/en/3.0/topics/db/qu...