On 7 Sep 2001, Petru Paler wrote:
> On Fri, 2001-09-07 at 14:13, Cristi Banciu wrote:
> > Trebuie sa fac ceva de genul:
> >
> > select * from tabel1 where camp1+' '+camp2 not in (select camp1 from tabel2)
> >
> > si nu stiu cum sa o fac sa mearga in mysql
>
> MySQL nu suporta subselecturi (in fine, nu suporta ultima data cand m-am
> uitat).
Asa e.
Dar se poate face astfel si e mai rapid ca executie:
select * from tabel1, tabel2 where tabel1.camp1+' '+tabel1.camp2 not in
tabel2.camp1
>
> (expecting a horde of mysql drones to flame me :)
>
>
> Petru
>
> ---
> Send e-mail to '[EMAIL PROTECTED]' with 'unsubscribe rlug' to
> unsubscribe from this list.
>
--
Cristian Paslaru
http://devel.iasi.ro
---
Send e-mail to '[EMAIL PROTECTED]' with 'unsubscribe rlug' to
unsubscribe from this list.
