Currently, a nested select() will return a Table named 'sub-tablename' where tablename is the table the select() was performed on.
If we try to join two nested tables that were from the same table, they will both have the same name, and that will cause a number of issues in identifying which table is which.
For nested queries, select a unique name for the returned Table.
For example:
a = select(t.c1, t.c2, where=t.c3 > 5, nest=True)
b = select(t.c1, t.c2, where=t.c4 == 'bizness', nest=True)
c = select(a.c1, b.c2, where=(a, b), join=(a.c5, b.c5))
Currently, a nested select() will return a Table named 'sub-tablename' where tablename is the table the select() was performed on.
If we try to join two nested tables that were from the same table, they will both have the same name, and that will cause a number of issues in identifying which table is which.
For nested queries, select a unique name for the returned Table.
For example:
will complain: