It certainly did help .
many thanks
On Aug 15, 4:41 pm, "King Simon-NFHD78" <[EMAIL PROTECTED]>
wrote:
> > -Original Message-
> > From: sqlalchemy@googlegroups.com
> > [mailto:[EMAIL PROTECTED] On Behalf Of mc
> > Sent: 15 August 2007 14:23
> > To: sqlalchemy
> > Subject: [sqlalchemy] Outerjoin with a subset of columns
>
> > Hi,
>
> > Note the following code:
>
> > oj=outerjoin(s,f)
> > r1=select([oj]).execute().fetchall()
> > r2=select([oj.left.c.id, oj.right.c.status]).execute().fetchall()
>
> > The first select executes a LEFT OUTER JOIN and returns all columns.
> > I wanted only 2 specific columns, so I tried the 2nd select.
> > That does not execute a LEFT OUTER JOIN, though.
>
> > How do I achieve my goal?
>
> You want to use the 'from_obj' parameter for select. Something like:
>
> select([s.c.id, f.c.status], from_obj=[oj])
>
> Hope that helps,
>
> Simon
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
