Yes, to me in the context of my particular select it was making issue that the order was not respected. However, as a workaround I can just define my join as a left join because my join was a one-one relation, but I see that it could happen I could just not get the proper SQL from my web2py query...
I guess that the keyed elements in the select() should be collected in a dict, so the order get loss?? Richard On Wed, May 7, 2014 at 4:43 AM, Niphlod <[email protected]> wrote: > there isn't any order defined between left and "normal" joins. > the exact same select would be created either with > > db().select(left=[], join=[]) > > or > > db().select(join=[], left=[]) > > If that's what you're pointing, you're out of luck ^_^ > > > On Tuesday, May 6, 2014 10:19:51 PM UTC+2, Richard wrote: >> >> Hello, >> >> I just struggle more than I would with this : >> >> db(...).select(..., >> left=[left1, >> left2, >> ...], >> join=join) >> >> I would expect that the JOIN be after the LEFT JOINS in SQL generated, >> since one of my left join was required to be before the join... >> >> Is there a reason why web2py change the order of join and left join ? >> >> Thanks >> >> Richard >> >> >> -- > Resources: > - http://web2py.com > - http://web2py.com/book (Documentation) > - http://github.com/web2py/web2py (Source code) > - https://code.google.com/p/web2py/issues/list (Report Issues) > --- > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
