Thanks a lot Sergey, It worked like a charm .
But can you please explain me about it ..?
i'm using sqlserver express 2005, and i thought that the joints are required only with MsAccess Database .. i thought that i could avoid these joints by using the "select from ... where ..=(select ... from ..) "
and i've read some topics about joins,which says that it is required when using MS Access only .
Anyway, this join has worked well although i didn't define anything related to the joins in my mapping files :|, shall i add properties to my mapping files inn order to use these joints ?
Is there any query composer, or something which helps in composing my HQl s graphically and get the query?
Thanks in advance, :D
by the way, thanks gert for the last reply
Regards,
Jojo Rico
_________________ In Code We Trust
|