How to use aliases in Crtiteria object.

[Fabio Daprile]

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]