Hi Emerson, I try the Option 2 and the result return a list of *DataRow *(which contains my expected values)
SQLTemplate query = new SQLTemplate(Table1.class,sql); query.setFetchingDataRows(true); List <DataRow> rows =(List <DataRow>) context.performQuery(query); Best Regards. -- View this message in context: http://cayenne.195.n3.nabble.com/Queries-with-multiple-tables-and-results-tp4006413p4006810.html Sent from the Cayenne - User mailing list archive at Nabble.com.