With a where clause, it works OK. However, in my example, I still should not have generated a CROSS JOIN. I guess it's just a pyDAL issue.
On Friday, 4 August 2017 17:25:14 UTC+1, villas wrote: > > According to the book, I should be able to append 'join' statements to a > list. Here is what happens: > > >>> joinlist = [] > >>> joinlist.append( db.res.on(db.extra_dates.res_id == db.res.id) ) > >>> joinlist.append( db.prop.on(db.res.prop_id == db.prop.id) ) > > >>> db()._select(db.prop.id, join=joinlist ) > > 'SELECT prop.id FROM extra_dates CROSS JOIN prop JOIN res ON > (extra_dates.res_id = res.id) JOIN prop ON (res.prop_id = prop.id) ORDER > BY prop.id;' > > This SQL is wrong and creates a ticket because an unwanted 'CROSS JOIN' > has been added. In my case I am using Firebird, but I believe this is > irrelevant because it happens in base.py which probably affects all DBs. > > I'm posting this initially here because the same problem > <https://groups.google.com/forum/#!searchin/web2py/cross$20join%7Csort:relevance/web2py/KpxWh4ikqG8/cDBbhiK_3F8J> > > was posted a couple of years ago. > > Maybe there's a workaround, or I'm missing something? > > > > > -- 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
