How to do INNER JOIN query in Tortoise ORM?

[clacknya]

class TEST(Model):
    a = fields.IntField()
    b = fields.IntField()
    c = fields.IntField()

    class Meta:
        table = 'test'

Raw SQL:

SELECT test.*
FROM test
INNER JOIN (
  SELECT a, MAX(b) AS max_b
  FROM test
  GROUP BY a
) AS t ON test.a = t.a AND test.b = t.max_b;

[thisisthemurph]

I am also interested in this, but I can't figure it out from the documentation.

I have code like:

delta = datetime.now().date() - timedelta(days=30)
top_movies = (
    await Movie.filter(release_date__gte=delta)
    .prefetch_related("reviews")
    .order_by("-reviews__audience_score", "-release_date")
    .limit(5)
)

but this is defaulting to a LEFT OUTER JOIN and I would like it to use an INNER JOIN. Any help would be appreciated.

[deadeyesky]

I want to do the same kind of thing but I have no idea how to do it.