id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
3358	select_related() should work with ValuesQuerySets	dbr <daniel.brandt@…>	nobody	"(Some of you may be reading this for the second or third time since I brought it up both on the django-developers list and IRC)

There appears to be no way to make a query like this through the django models without using SQL or hitting the database twice:
{{{
SELECT
trackback.title, blog.name, blog.url
FROM trackback INNER JOIN blog 
ON trackback.blog_id = blog.id 
}}}

As far as I know, selecting with table fields is preferred above using a SELECT * any time possible.

I understand this would break the model object to table row mapping of the !QuerySet (objects woulnd't be complete if some fields
were missing), perhaps a new kind of !QuerySet or !ValueQuerySet is needed? 

If this is something that would be a welcome addition to the codebase, I could probably help out.

"		closed	Database layer (models, ORM)			duplicate			Accepted	0	0	0	0	0	0