[Answer]-How to convert sql join into django

You can use select_related(). Like this manner,

names = testcasecache.objects.select_related('keyword').order_by('-name')

https://docs.djangoproject.com/en/dev/ref/models/querysets/#select-related

By using keywordcache table you can fetch the particular keyword of that particular test case
name=testcasecache.objects.filter(keyword=kid,testcase=tid)
where tid is ur testcase id
and kid is your keyword id