I am sorry. I am the problem. I should use outer join.
I was confused , because not mentioning the reference table in the query and mentioning it in the select, will generate product of the tables. Again, I am sorry. Regards, Ashraf On Sunday, June 2, 2013 2:21:25 PM UTC+3, Alan Etkin wrote: > > As i remember, one year ago, I had to include the referenced table in the >> query, so that it can be used in the select. >> > > Can you give us a source code example of the problem/question? > -- --- 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 [email protected]. For more options, visit https://groups.google.com/groups/opt_out.

