thanks, yes i just realised i don't need the joint for the filtering. On Monday, February 24, 2014 4:57:37 PM UTC+2, Anthony wrote: > > t_b = db.t_b.f_x ==3 >> > > Doesn't look like you do anything with the above. Why not: > > rows = db((db.t_a.created_by == auth.user.id) & (db.t_b.f_x == 3)).select( > join=db.t_b.on(db.t_a.f_test == db.t_b.id)) > > Note, you can also do a join via: > > rows = db((db.t_a.created_by == auth.user.id) & (db.t_b.f_x == 3) & > (db.t_a.f_test == db.t_b.id)).select() > > Technically, that will implement the join via a SQL WHERE clause rather > than the JOIN statement. > > Anthony >
-- 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/groups/opt_out.