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