Sun Java System Application Server Platform Edition 9 Release Notes

Solution

A possible workaround is to directly navigate the relationship instead of defining a JOIN variable; for example:


SELECT AVG(o.totalPrice), o.customer FROM Order GROUP BY o.customer