Hi, you could create a view and map that on a class that represents that view, then you dont need QueryBySQL.
regards, Dennis 2007/7/24, krupa <[EMAIL PROTECTED]>:
Hi All, I have several SQLs already written. I want to use QueryBySQL to use the existing SQLs. The problem I am facing is how do I map the result set of these queries to my java classes, especially if I have a result set that includes fields from 3 tables then how do I map this in the reposity.xml file? Please help me with this. here is an example of my SQL statement. select A1.field1, A1.field2, A1.field3,A2.field1, A2.field2,A2.field3,A2.field4, A3.field1 as tmp1, A3.field2 as tmphdr2 from (((Table1 left outer join table2 on field1= field2) left outer join table2 A2 on field2 = A2.field2) left outer join table2 A3 on field5= A3.field2) left outer join table2 A4 on field6 = A3.field2 where field1= 12 and field8 = ''A'' order by field9 ; Thanks, Krupa -- View this message in context: http://www.nabble.com/QueryBySQL-tf4137474.html#a11768006 Sent from the Apache DB - ObjectRelationalBridge Users mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
-- mvg, Dennis
