Hello, I was wondering what the syntax was to do a SQL JOIN on more than 2 tables. I understand the syntax for 2 tables is:
db(db.table1.col == db.table2.FKcol).select() What if I want to JOIN the above resultset with more tables? I tried nesting the statements like: db(db(db.table1.col == db.table2.FKcol)).table2Col == db.table3.col3).select() but that didn't seem to work. Any help is appreciated. Thanks!
