如何将下面的 SQL 状态转换为 Django ORM

Question

很难将下面的 SQL 语句转换为 Django ORM。任何帮助深表感谢。SELECT a.state,        a.city,        a.postcode,        b.rate_authority,        b.rate,        b.rate_descr FROM   fileload_taxratemodel AS a        INNER JOIN fileload_taxrateresponsemodel AS b                ON b.jurs_id_id = a.id ORDER  BY state ASC Django 模型：尝试根据外键从两个模型中提取字段。class TaxRateModel(models.Model):company_code = models.CharField(max_length = 10)document_date = models.DateTimeField()country = models.CharField(max_length = 30, default = "US")province = models.CharField(max_length = 100, null= True,blank= True)state = models.CharField(max_length = 100)county = models.CharField(max_length = 100,blank=True, null=True)city = models.CharField(max_length = 100,blank=True, null=True)district = models.CharField(max_length = 100, blank=True, null=True)postcode = models.CharField(max_length = 5, blank=True, null=True)rate_code = models.CharField(max_length = 30,default = "ST")Django 2 模型：class TaxRateResponseModel(models.Model):jurs_id = models.ForeignKey(TaxRateModel,on_delete=models.CASCADE,related_name='rates')rate_authority = models.CharField(max_length = 100, blank=True, null=True, default='')rate_descr = models.CharField(max_length = 100, blank=True, null=True, default ='')rate = models.DecimalField(max_digits= 10, decimal_places=5)