On Wednesday, October 26, 2022 at 5:38:44 PM UTC-7 Jim S wrote: > Can you try > > vrows = db(db.picsntoes.id > 0 <http://db.pics.id>).select(db.pics.ALL, > db.picnotes.ALL, left=db.pics.on(db.pics.id == db.picnotes.about)) > > instead of > > vrows = db(db.pics.id == db.picnotes.about).select(db.pics.on(db.pics.id > == db.picnotes.about)) > > Thank you! That worked. And it turns out my version would have worked if I hadn't dropped the "join =". But because of a typo in a text comparison, I was actually executing a different query, from before I tried a simplified problem. Now that you've helped my through the simplified problem, I can go back and see how far I get in the deeper mud.
If that doesn't work, can you share you're whole model? Seems like the > picnotes def is off a bit. > > -Jim > Dave S /dps > [original post elided] >> > -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/26621102-1b40-492a-a5d1-830a01ae4033n%40googlegroups.com.