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, left=joinlist ) 'SELECT prop.id FROM extra_dates CROSS JOIN prop LEFT JOIN res ON (extra_dates.res_id = res.id) LEFT 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.
