I have three tables - Person: id, first_name, last_name, deleted, last_update Email: id, email_address, email_type Person_Email: id, person_id, email_id, primary_email
I want to create a view that returns the result of this query as a jason object: select person.id, first_name, last_name, deleted, last_update, email_address, email_type, primary_email, from person left join (email, person_email) on (person.id=person_email.person_id and email.id=person_email.email_id ); I am struggling with how to convert this sql query into django syntax. I have been reading this part of the tutorial - https://docs.djangoproject.com/en/1.3/topics/db/queries/, but I am not seeing how to make the translation. I am using django 1.3. Thanks! Mark -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
