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
