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.c...@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-unsubscr...@ibatis.apache.org > For additional commands, e-mail: user-java-h...@ibatis.apache.org > >
--------------------------------------------------------------------- To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org
