I assume that you want to select all users without a list? You will need to construct a set that contains all users and possible joined list field. This set can than be filtered using the fields in the list table. This is a typical leftjoin case wich can be peformed as folows:
User.select(List.q.userID==None, join=LEFTJOINOn(User, List, User.q.id==List.q.userID)) This will create something like: SELECT * FROM user LEFT JOIN list ON user.id=list.user_id WHERE list.user_id IS NOT NULL --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
