Solved by using this:
works = MusicalWork.objects.select_related('composer').all()And accessing it with this str(item.title) + ' -- ' + str(item.composer.last_name) On Sunday, May 18, 2014 10:14:30 AM UTC-4, Nino Cocchiarella wrote: > > 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; > -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/django-users. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/6d39a066-558a-4139-90c4-62309078947c%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
