ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Diran Ayandele <Adediran.Ayand...@Sun.COM>
Subject Re: query inside a query
Date Fri, 05 May 2006 22:12:06 GMT
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


Mime
View raw message