Or at least, that's what it looks like I want to do. The relevant part of my model looks like this:
class MoneyStream(SQLObject): users = RelatedJoin('User') label = UnicodeCol() class User(SQLObject): moneystreams = RelatedJoin('MoneyStream') What I want to do is, given a user (current.user) and a label, find the MoneyStream that with that label that has that user in its users list. How do I write the select? Or should I just scan through User.moneystreams? --David ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss