ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nathan Maves <nathan.ma...@gmail.com>
Subject Re: Writing subqueries
Date Wed, 27 Jan 2010 15:25:06 GMT
yes

On Jan 27, 2010, at 1: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
> 

Nathan Maves
nathan.maves@gmail.com




---------------------------------------------------------------------
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