Do a (left) join. (About joins:
And on how to do it with SQLObject: and


2007/6/8, Nick Murdoch <>:
Hi all,

I have two classes (simplified here):

class ContactDetails(SQLObject):
     email = UnicodeCol(alternateID=True)

class VIPContactDetails(ContactDetails):

Is there any way I can perform a select across both classes, something
like (in my head):
(ContactDetails & VIPContactDetails).select(...)

The alternative seems to be to just perform a select on each class and
merge them together in Python, which isn't particularly convenient when
I intend to pass orderBy and so on into select().


Nick Murdoch

This 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.
sqlobject-discuss mailing list