Re: Need Help Converting SQL statement into Django Query Syntax

On Sun, May 6, 2012 at 9:24 AM, Dennis Lee Bieber wrote: > On Sun, 6 May 2012 08:16:02 -0700, Mark Phillips > declaimed the following in > gmane.comp.python.django.user: > > > I have three tables - > > Person: id, first_name, last_name, deleted, last_update > > Email: id, email_address, email_typ

Need Help Converting SQL statement into Django Query Syntax

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