Hi I've a sqlmap to a class that is filled with data from a select but one field should be getted from another table and then I wonder if is posible to make the second select in the same sqlmap file and return data filled.
My sqlMap is ----------- <?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN" "http://www.ibatis.com/dtd/sql-map-2.dtd";> <sqlMap namespace="Participes"> <typeAlias alias="participes" type="org.jl.meriden.listados.dao.Participes" /> <select id="selectParticipes" resultClass="participes"> <![CDATA[ select E10CTA as nroCuenta, E10TSU as suscriptas, E10TRE as reembolsadas, E10TIT as saldoParticipe, E10TPG as saldoPignorado, E10PSU as saldoSuscripto, E10PRE as saldoRembolsado, E10PCM as saldoCosteMedio from dpicfic.E10PI where E01PI.E01FBA <> 0 ]]> </select> </sqlMap> ------------ and I need to add another field that comes from another select that receives E10CTA as parameter. Thanks in advance -- Javier Leyba Barcelona - Spain http://blog.leyba.com.ar
