Yes, it is possible. Check this http://www.mail-archive.com/[EMAIL PROTECTED]/msg3 9568.html
> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Steffen Gransow > Sent: Thursday, January 29, 2004 6:21 PM > To: [EMAIL PROTECTED] Sourceforge. Net > Subject: [JBoss-user] Are inner joins possible? > > Hi, > > I'm wondering, if multiple inner joins are possible using > jboss-ql or similar. I'm new to this and did only provide > some simple queries so far. > Here's one example: > > SELECT teilnehmer.pkey, > teilnehmer.titel, > teilnehmer.vorname, > teilnehmer.nachname, > teilnehmer.ort, > teilnehmer.fk_kv, > teilnehmer.teilnehmer_id > FROM > kommission INNER JOIN teilnehmer ON > kommission.fk_teilnehmer = teilnehmer.pkey > INNER JOIN kv ON kommission.fk_kv = kv.pkey WHERE > kv.kvid = 6 > > How do I implement such queries? Or if this doesn't work with > ejb-ql or jboss-ql, what other possibilities do I have? > > Thanks in advance > > Steffen Gransow > > > > > ------------------------------------------------------- > The SF.Net email is sponsored by EclipseCon 2004 Premiere > Conference on Open Tools Development and Integration See the > breadth of Eclipse activity. February 3-5 in Anaheim, CA. > http://www.eclipsecon.org/osdn > _______________________________________________ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user > > ------------------------------------------------------- The SF.Net email is sponsored by EclipseCon 2004 Premiere Conference on Open Tools Development and Integration See the breadth of Eclipse activity. February 3-5 in Anaheim, CA. http://www.eclipsecon.org/osdn _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user