do you recall the number of the issue you filed? I filed and fixed an issue about a similar problem. The only difference is that my query uses inner joins instead of outer joins: https://glassfish.dev.java.net/issues/show_bug.cgi?id=2867
Regards Michael
[Message sent by forum member 'mb124283' (mb124283)]