如何在Django中执行内部联接 [英] How to perform inner join in django
本文介绍了如何在Django中执行内部联接的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
句子:
select * from auth_permission left join
auth_group_permissions on (auth_group_permissions.permission_id = auth_permission.id)
我该如何在Django中使用queryset我不了解内部联接如何在querysets中工作
Taking the sentence:
select * from auth_permission left join
auth_group_permissions on (auth_group_permissions.permission_id = auth_permission.id)
How can i do in django with queryset i do not understand how the inner join works in querysets
在默认Django身份验证模式中
in models of default django auth
我已经做到了:
permiso = Permission.objects.all().select_related()
...: for x in permiso:
...: print(x.group_set.all().query)
并在每个循环中查看:
SELECT "auth_group"."id", "auth_group"."name" FROM "auth_group" INNER JOIN "auth_group_permissions" ON ("auth_group"."id" = "auth_group_permissions"."group_id") WHERE "auth_group_permissions"."permission_id" = 1255
推荐答案
您可以通过 查看全文