See this: http://web2py.com/books/default/chapter/29/06#Inner-joins
On Thu, Jun 27, 2013 at 7:45 AM, mcamel <mca...@gmail.com> wrote: > Hi, > > I have the same problem with a legacy MySQL database. > > We have different Schemas and need to use plenty of JOINs of tables from > different Schemas. I've couldn't find any solution for this in the > documentation, so the only way i've found is writing the SQL of my own, like > in: > > SELECT b.serial, p.name > FROM Hardware.boards b > INNER JOIN Software.products p ON p.type = b.type > > Is there something "stable" in DAL to do this?. > > > Thanks in advance. > > Best regards, > Manuel. > > -- > > --- > 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/groups/opt_out. > > -- --- 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/groups/opt_out.
