How to use DAL for this query

[Nino Cocchiarella]

I'm working with Django... I am used to writing raw SQL queries, so the DAL is a little comfusing for me.  But, apperantly, its the thing to do.

Anyway, come anyone point me in the right direction on how to translate this raw query into the Django DAL --

SELECT *  FROM rep_musicalwork, rep_composer WHERE rep_musicalwork.composer_id = rep_composer.id ORDER BY rep_composer.last_name, rep_composer.first_name;

[Nino Cocchiarella]

Solved by using this:

works = MusicalWork.objects.select_related('composer').all()

And accessing it with this

str(item.title) + ' -- ' + str(item.composer.last_name)