EJB-QL problem ???

[ericmacau]

Hello,

How can I define a EJB-QL to for the following conditions ?
1. to retrieve all the Goals for a specific Player and a specific Season

+------+ +----------+
| Goal |------------- | Player |
+------+ * 1 +----------+
 *|
 |
 1|
+---------+
| Season |
+---------+


Player 1:N Goal
Season 1:N Goal


I want to get all the Goals for Player(playerId=1) and Season(seasonId=1).

How to define the EJB-QL ???

[julien.dubois]

SELECT OBJECT(g) FROM Goal AS g
WHERE g.player.playerId=?1
AND g.season.seasonId=?2