I think it is a bug. Please open a ticket linking this thread.
On Thursday, 2 January 2014 13:20:04 UTC-6, ssuresh wrote:
>
> I found a peculiar problem when executing a join query on two tables. I
> have two tables table1 and table2. Both have ids as their pks. table1 has a
> FK on table2 using table2_id field.
>
> Now when i do an executesql of the following query,
>
> rows=executesql('select * from table1,table2 where table1.table2_id=
> table2.id',as_dict=True)
>
> I always get only one id field in the return dict and I dont know whether
> the id is of table1 or table2.
>
> Am I doing something wrong, or is it a possible bug?
>
--
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 [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
