Hi all
I need to generate all possible pairs of lines matching some criteria,
on SQL I used something like this for testing:
#
SELECT *
FROM table, table AS table_alias
WHERE
table.x = table_alias.x
#
With SQLObject I tried using sqlbuilder.Alias, like this:
<code>
TableAlias = sqlbuilder.Alias(Table, 'table_alias)
query = Table.select(Table.q.x == TableAlias.q.x)
</code>
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
--
Pedro Werneck
|