yes On Jan 27, 2010, at 1:11 AM, [email protected] 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: [email protected] > For additional commands, e-mail: [email protected] > Nathan Maves [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
