ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Wesley Acheson <wesley.ache...@gmail.com>
Subject Re: Writing subqueries
Date Fri, 29 Jan 2010 10:43:06 GMT
Thats just an update query. I'm not sure what the difficulty you have is?

On Wed, Jan 27, 2010 at 9:11 AM,  <fran.cois@free.fr> wrote:
>
> Hi all.
> As a new iBatis user, I'd like to know how is it possible to write a statement
> like this one:
>
>
> INSERT into table1 (ville, nom, datn)
> SELECT l.ville, l.nom, v.datn
> from mtab l, dpart b, table3 v
> where b.nom=l.nom
> and (b.nom,v.datn) not in (SELECT x.nom,x.datn from table1 x)
>
>
> Any example of an Insert or Update subquery would be helpful.
> Thanks in advance.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
> For additional commands, e-mail: user-java-help@ibatis.apache.org
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org


Mime
View raw message