I need to generate all possible pairs of lines matching some criteria,
on SQL I used something like this for testing:
FROM table, table AS table_alias
table.x = table_alias.x
With SQLObject I tried using sqlbuilder.Alias, like this:
TableAlias = sqlbuilder.Alias(Table, 'table_alias)
query = Table.select(Table.q.x == TableAlias.q.x)
But I don't get pairs of objects like I expected. I'm new to SQLObject
and searched the docs for something like this, but nothing.
Is it possible to do it in a single query like I want ? How to do it ?
Thanks for your help