Look at the ibatis devloper guide on complex properties page 26.... Steve
________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tue 11/04/2006 14:29 To: [email protected] Subject: Using join query Hi, I am new to iBatis. I want to fetch the data from the multiple tables. How do i specify the multiple result classes. ?? or give me select query. These are my classes: User { private int id, private String name; } These details are stored in USR_DETAILS table. Also User can have multiple properties. These are stored in USR_PROPERTIES table. UserProperties { private int userId; private String name; private String value; } It is possible that one user can have multiple properties. select * from USR_DETAILS , USR_PROPERTIES where USR_DETAILS .USR_ID=USR_PROPERTIES .USR_ID; The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you.
<<winmail.dat>>
