Re: [Hibernate] Combination of 3 classes and display the result

2006-07-05 Thread Emmanuel Bernard
This is the Hibernate developement mailing list Please go to the user forum for such questions http://forum.hibernate.org edwarddurai wrote: > Hi, > > I have 3 tables in MSSQL Database. > > 1. Auditfinding > 2. AuditfindingsDisplayName > 3. AuditFindingsFieldList > > Fine. I have Created Mapping

[Hibernate] Combination of 3 classes and display the result

2006-07-05 Thread edwarddurai
Hi, I have 3 tables in MSSQL Database. 1. Auditfinding 2. AuditfindingsDisplayName 3. AuditFindingsFieldList Fine. I have Created Mapping Files And Java Bean files(Using getter and setter methods) My Hibernate Query is Working Perfectly. My Query is: select distinct Id as AuditId,substring(s