CODEWITHSUNDEEP
django-models
sridhar
sridhar

Reputation: 21

how can write this query in django ORM

how to write in django ORM query select all rows(id) which id not userreg

select * from userreg where user_id not in (select user_id from emp_details)

Upvotes: 0

Views: 30

Answers (1)

aslavkin
aslavkin

Reputation: 224

Something like this:

from django.db.models import Q
emp_id_list = Emp_details.objects.values('user_id')
res_list = Userreg.objects.filter(~Q(user_id__in = emp_id_list))

Upvotes: 1

Related Questions