mysql - Django ORM Join 语句

Question

我在将两个表中的数据连接在一起时遇到问题。

我的模型如下所示:

class Student(models.Model):
    name = models.CharField(max_length=50)
    surname = models.CharField(max_length=50)
    sex = models.CharField(max_length=10, choices=SEX_CHOICES)
    kod_baka = models.CharField(max_length=20)
    school_class = models.ForeignKey(School_class)
    rfid = models.CharField(max_length=20, null=True)

class User_account_student(models.Model):
    kod_baka = models.CharField(max_length=20)
    login = models.CharField(max_length=50, null=True, editable=False)
    default_passwd = models.CharField(max_length=50, null=True)

我需要做的是从这两个表中一起选择数据，并通过列kod_baka链接。 SQL 查询看起来像

SELECT *
FROM Student
INNER JOIN User_account_student ON
    Student.kod_baka = User_account_student.kod_baka`

有什么建议吗？谢谢。

Answer 1

class Student(models.Model):
    name = models.CharField(max_length=50)
    surname = models.CharField(max_length=50)
    sex = models.CharField(max_length=10, choices=SEX_CHOICES)
    kod_baka = models.CharField(max_length=20)
    school_class = models.ForeignKey(School_class)
    rfid = models.CharField(max_length=20, null=True)

class User_account_student(models.Model):
    kod_baka = models.CharField(max_length=20)
    login = models.CharField(max_length=50, null=True, editable=False)
    default_passwd = models.CharField(max_length=50, null=True)

class Membership(models.model):
    student=models.ForeignKey(Student)
    user_account_student=models.ForeignKey(User_account_student)


s = Student.objects.get(....).kod_baka
User_account_student.objects.filter(membership__student.kod_baka = s).distinct()