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 <update> tag:
<update id="insertFoo">
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)
</update>
I recommend just giving ibatis a testdrive and actually playing with it a
little.
-----Ursprüngliche Nachricht-----
Von: F. TRAORE [mailto:[email protected]]
Gesendet: Freitag, 29. Januar 2010 13:07
An: [email protected]
Betreff: Re: Writing subqueries
> Thats just an update query. I'm not sure what the difficulty you have is?
>
Just an update query ? Two select into one insert ? Excuse me for
disturbing you if you're an iBatis expert and please don't lose your
time more longer...
As I said I'm new on iBatis and just want to know how to to embed a
statement within another.
Thanks for any example.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
