django 的 ForeignKey 查询问题

[erevus]

models.py

class A (models.Model ):
    name = models.CharField (u'作者')
  class B (models.Model ):
    author = models.ForeignKey (A )
    book = models.CharField (u'书籍')

怎么查询出所有
"A.name,B.book"
这样的数据?

[IanPeverell]

$python manage.py shell

>>>from XXX.models import A,B
>>>A.objects.all (),B.objects.all ()

不知道你是不是问的是这个…

[wenbinwu]

> books = B.objects.select_related ('author').all ()
> [(b.author.name, b.name ) for b in books]
这样？

[erevus]

@wenbinwu books = B.objects.select_related ('author').all () 对 就是这个