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 o
I was waiting for something more complex !
Thanks for your reply... and for the advice !
Best regards.
Selon Stephen Friedrich :
> The statement you gave is a single statement.
> iBatis doesn't care (or know) how many subqueries it contains.
> You can simply use a single tag:
>
>
>INSERT
