Re: [SQLObject] How do I do a LEFT JOIN

[Ian B. <ia...@co...>]

On Mon, 2003-07-07 at 15:27, Mark Melvin wrote:
> Hi all,
> 
> I am super-excited about this package, but I can't seem to figure out how 
> do execute a simple LEFT JOIN SQL query.  Am I missing somehting basic 
> here?  I have my two tables set up, but I can't issue the SQL directly with 
> the .select() method because it throws that pesky WHERE in at the end.  
> Here is what I am getting:

I'm glad you are excited about it.  You can't really do a left join, but
you can get the same thing iteratively, like:

for customer in Customer.select():
    contacts = customer.Contacts

You can't fetch the customers and the contacts together -- SQLObject
only knows how to select instances of one class at a time (this is made
up for by the fact it's easy to get related instances, as in
"customer.Contacts").

  Ian