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 _______________________________________________ sqlobject-discuss mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
