Django Model API using MySQL: INNER JOIN

[7D8]

anyone know how to do an MySQL INNER JOIN in Django's model query API?

I want to get something like this:

select a.myName, a.myAddedDate, b.myCred, b.myNote from mywords_myword as a INNER JOIN mywords_credential as b on (a.myword_id =b.id)

Originally Posted by tomek

anyone know how to do an MySQL INNER JOIN in Django's model query API?

I want to get something like this:

select a.myName, a.myAddedDate, b.myCred, b.myNote from mywords_myword as a INNER JOIN mywords_credential as b on (a.myword_id =b.id)

hmmm... nevermind, I think I partially found it.