On Fri, Jun 08, 2007 at 06:11:11PM +0100, Nick Murdoch wrote: > The relevant part there is SELECT * from (SELECT * FROM vip_comp_details > UNION SELECT * FROM contact_details ), I guess.
UNION is meaningless for high-level SQLObject API. The only way to do UNION is: connection.queryAll("SELECT * ...") Oleg. -- Oleg Broytmann http://phd.pp.ru/ [EMAIL PROTECTED] Programmers don't die, they just GOSUB without RETURN. ------------------------------------------------------------------------- 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