Hello there...
> however, if you want to chain the joins themselves together, you
> probably want to construct the Join object ahead of time
I was looking for examples on how to do this but I couldn't find it. I
tried a few variations of this:
# tbl_a, tbl_b, and tbl_c are Table objects
tables = [tbl_a]
chained_joins = tbl_a
collections = [tbl_b, tbl_c]
for tbl in collections:
tables.append(tbl)
chained_joins.outerjoin(tbl)
sql = select(tables).select_from(chained_joins)
Any hints are appreciated :)
Thanks!
g.
On Friday, 6 April 2007 13:04:40 UTC-7, Michael Bayer wrote:
>
> the select object supports an append_from() method.
>
> and add it
> to the select via append_from() (or create the select by calling the
> select() method off the Join itself) once its complete.
>
>
> On Apr 6, 2007, at 3:52 PM, vkuznet wrote:
>
> >
> > Hi,
> > is there are any way to add additional joins to a given select object?
> >
> > My problem is the following, I need to join the same table multiple
> > times. How many times I don't know in advance and in addition I need
> > to apply where clause while adding this join.
> >
> > Thanks,
> > Valentin.
> >
> >
> > >
>
>
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" 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/sqlalchemy.
For more options, visit https://groups.google.com/groups/opt_out.
