how can i have a subquery in django's queryset? for example if i have:

select name, age from person, employee where person.id = employee.id and
employee.id in (select id from employee where employee.company = 'Private')

this is what i have done yet.

Person.objects.value('name', 'age')
Employee.objects.filter(company='Private')

but it not working because it returns two output...

as mentioned by ypercube your use case doesn't require subquery.

but anyway since many people land into this page to learn how to do sub-query here is how its done.

from django.db.models import Subqueryemployee_query = Employee.objects.filter(company='Private').only('id').all()
Person.objects.value('name', 'age').filter(id__in=Subquery(employee_query))

Source: http://mattrobenolt.com/the-django-orm-and-subqueries/