yes On Jan 27, 2010, at 1: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 > Nathan Maves nathan.ma...@gmail.com --------------------------------------------------------------------- To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org
