On Wed, May 02, 2007 at 07:09:52PM +0400, Oleg Broytmann wrote: > That's because you have used the tables (aliases) both in "where" clause > and in join. Tables from "where" (from OR() in this example) are used in > FROM clause in the generated SQL.
And the question is - if they have to be removed from FROM. I will think about it to understand if it's a bug in SQLObject... 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