rive and actually playing with it a
> little.
>
> -Ursprüngliche Nachricht-
> Von: F. TRAORE [mailto:fran.c...@free.fr]
> Gesendet: Freitag, 29. Januar 2010 13:07
> An: user-java@ibatis.apache.org
> Betreff: Re: Writing subqueries
>
>
> > Thats just an update qu
f: 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
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 em
Thats just an update query. I'm not sure what the difficulty you have is?
On Wed, Jan 27, 2010 at 9:11 AM, 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.d
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.n
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
