You could also write an inner query joined on the E10CTA column whose
syntax would depend on your database.
Javier Leyba wrote:
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
