To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=116509
------- Additional comments from fd...@openoffice.org Fri Jan 28 09:02:02 +0000 2011 ------- All subqueries give good results. the query SELECT e.unfct_ident, e.annee, e.numlabo, tp.TAPR_LIB_TACHE, tp.TAPR_CODE_TACHE, a.ACDG_CODE_ACTION FROM echantillon AS e LEFT OUTER JOIN tache_programmee AS tp ON tp.TAPR_CODE_INTERNE=e.TAPR_CODE_INTERNE AND tp.ID_SERVICE_ORIGINE=e.ID_SERVICE_ORIGINE_TACHE LEFT OUTER JOIN activite_dg AS a ON a.ACDG_CODE_INTERNE=tp.ACDG_CODE_INTERNE WHERE e.annee=2010 and e.numlabo<3 has as result the row 170 2010 2 0 0 32 with WHERE e.annee=2010 and e.numlabo=2 no result was found --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org