"kerinin" <[EMAIL PROTECTED]> writes: > SELECT transaction WHERE ( transaction.budget == budget AND > transaction.transaction_class IN tabulation.positive_classes )
This doesn't make much sense the way it is written. I'll answer as if it was proper SQL and the names before the dot are tables... You'll have to make more than one query with SQL Object. One to retrive tabulation.positive_classes then select from transaction using sqlbuilder's AND and filtering with the positive_classes list. Another option is writing proper SQL and translating it with sqlbuilder's join. There are join examples on SQL Object's FAQ and http://www.sqlobject.org/SQLObject.html#left-join-and-other-joins Finally, you can use sqlbuilder to write your subselect: http://www.sqlobject.org/SQLObject.html#subqueries-subselects -- Jorge Godoy <[EMAIL PROTECTED]> --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "TurboGears" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/turbogears?hl=en -~----------~----~----~----~------~----~------~--~---
