Look at the javadocs for the Criteria object. The method that you want to use is Criteria.addAlias().
> -----Original Message----- > From: Fabio Daprile [mailto:[EMAIL PROTECTED]] > Sent: Monday, February 03, 2003 9:42 AM > To: Turbine Users List > Subject: How to use aliases in Crtiteria object. > > > Hello everybody, > > i would like to ask you how it is possible to implement the following > query using the Criteria object: > > select a.ticketId > from > TicketVersions as d, TicketVersions as a, Versions as b, > Versions as c where > ((a.versiontype = 'Fixed' and b.description = 'not set') and > (a.versionid = b.id)) > and > ((d.versiontype = 'Raised' and c.description = 'PB_INC5')and > (d.versionid = c.id)) > and > (a.ticketid = d.ticketid) > > ii'll be grateful for any help. > > thx in advance > > Fabio Daprile > > -- > Fabio Daprile > > W�rth Phoenix srl - GmbH > Via Kravoglstrasse 4 > 39100 Bolzano / Bozen > Tel. +39 0471 564 111 - (direct 564068) > Fax + 39 0471 564 122 > [EMAIL PROTECTED] > http://www.wuerth-phoenix.com http://www.wuerth.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
