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.
