ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From fran.c...@free.fr
Subject Writing subqueries
Date Wed, 27 Jan 2010 08:11:08 GMT

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

View raw message