I see these lines in your code: <join table="works_info"> <key column="pk_work_id"/> <property name="work_name" column="work_name" type="java.lang.String"/ >
But the main class Tendor doesnt contain any thing which will join this table with Works_Info. Thanks, Prabhat Kunal Raikar wrote: > I am using hibernate. In that I want to fetch data from 3 different tables > for that my hbm.xml file look like this:- > > <class name="com.netechinc.forms.TenderForm.TenderAwardDetailsSearchForm" > table="TENDER"> > <id name="pk_tender_id"> </id> > <property name="tender_no" column="tender_no" type="java.lang.String"/> > <property name="tender_date" column="createdate" > type="java.lang.String"/> > > <join table="tender_details"> > <key column="Tender_Id"/> > <property name="work_no" column="work_no" type="java.lang.String"/> > </join> > </class> > > > Here I am fetching data from table TENDER and TENDER_DETAILS. its working > fine but when I use following code :- > > <class name="com.netechinc.forms.TenderForm.TenderAwardDetailsSearchForm" > table="TENDER"> > <id name="pk_tender_id"> </id> > <property name="tender_no" column="tender_no" type="java.lang.String"/> > <property name="tender_date" column="createdate" > type="java.lang.String"/> > > <join table="tender_details"> > <key column="Tender_Id"/> > <property name="work_no" column="work_no" type="java.lang.String"/> > </join> > > <join table="works_info"> > <key column="pk_work_id"/> > <property name="work_name" column="work_name" > type="java.lang.String"/> > </join> > </class> > > > to fetch the data from 3 table it does not give me any results. Plese help > me > -- > Warm regards > Kunal > > -- > You received this message because you are subscribed to the Google > Groups "Java EE (J2EE) Programming with Passion!" group. > To post to this group, send email to > java-ee-j2ee-programming-with-passion@googlegroups.com > To unsubscribe from this group, send email to > java-ee-j2ee-programming-with-passion+unsubscr...@googlegroups.com > For more options, visit this group at > http://groups.google.com/group/java-ee-j2ee-programming-with-passion?hl=en?hl=en -- You received this message because you are subscribed to the Google Groups "Java EE (J2EE) Programming with Passion!" group. To post to this group, send email to java-ee-j2ee-programming-with-passion@googlegroups.com To unsubscribe from this group, send email to java-ee-j2ee-programming-with-passion+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/java-ee-j2ee-programming-with-passion?hl=en?hl=en