Django ORM is pretty awesome however it has some limitations. One of such limitations is the ability to use sub-queries. Actually thats not 100% true since Django ORM can use nested queries however ...

The wrong query seems to be generated which also returns the wrong results. I'm using 3 tables in my simplified examples (Emp, Dep, EmpDep), to demonstrate the problem (i've attached the full example ...