Get all fields with join. DJANGO

Question

If I do

books = Book.objects.filter(author__name="John")

I get only Book's fields

How can I get Author's fields too, With single query?

Answer 1

Use values or values_list:

books_info = Book.objects.filter(author__name="John").values('book_field1', 'book_field2', 'book__author_field1','book__author_field2')

django docs:

https://docs.djangoproject.com/en/1.8/ref/models/querysets/#values https://docs.djangoproject.com/en/1.8/ref/models/querysets/#values-list