Do a (left) join. (About joins: http://www.w3schools.com/sql/sql_join.asp)
And on how to do it with SQLObject:
http://www.sqlobject.org/FAQ.html#how-can-i-do-a-left-join and
http://www.sqlobject.org/SQLObject.html#left-join-and-other-joins
TiNo
2007/6/8, Nick Murdoch <[EMAIL PROTECTED]>:
Hi all,
I have two classes (simplified here):
class ContactDetails(SQLObject):
email = UnicodeCol(alternateID=True)
class VIPContactDetails(ContactDetails):
pass
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().
Thanks,
Nick Murdoch
-------------------------------------------------------------------------
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
-------------------------------------------------------------------------
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
