[Answer]-Simulating an inner join with django's orm and no explicit foreign key

This might be a perfectly fine time to use the .raw() method; you can specify the exact SQL and get the result as a the normal Django result list of objects.