Hi all !

Does anybody know how can I do to make an alias in my Criteria ?

The request is the next one :

select person.name, person1.name
from person, person as person1, training, cursus
where training.training_number = 1
and training.status IN('in','nt')
and training.master_sid = person.person_sid
and training.cursus_sid = cursus.cursus_sid
and cursus.student_sid = person1.person_sid;

Regards

jv



------------------------------------------------------------
To subscribe:        [EMAIL PROTECTED]
To unsubscribe:      [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?:           [EMAIL PROTECTED]

Reply via email to