Django sql in查询

26 down vote favorite

2

I'm trying to figure out how to write a 'not in' style query in django.For example, the query structure I'm thinking of would look like this.

select table1.* from table1where table1.id not in (  select table2.key_to_table1  from table2   where table2.id = some_parm )

What would the django syntax look like assuming models called table1 and table2?

sql django

share|improve this question

asked Dec 23 '10 at 23:42 Turbo 73921123

add comment

4 Answers

active oldest votes

up vote 37 down vote accepted

table1.objects.exclude(id__in = table2.objects.filter(your_condition).values_list('id', flat=True))

The exclude function works like the Not operator you where asking for. The attribute flat = True tells to table2 query to return the value_list as a one level list. So... at the end you are obtaining a list of IDs from table2, which you are going to user to define the condition in table1, that will be denied by the exclude function.

share|improve this answer

edited Oct 25 '12 at 17:27

answered Aug 26 '11 at 4:49 Harph 505512