Well I actually noticed a press release a few days ago
saying that the latest version (4.0.10??) is
supporting sub-slelect... please check the website.
this following should be working:
select nome from categorias, categoriamembro
where categoriamembro.id_categoria =
categorias.categoria and
c
Sadly MySQL does not support sub-selects yet. Take a look at the manual for
suggestions of ways around it.
Keith
Extranet
[EMAIL PROTECTED] - 06/02/2003 02:31
To:mysql
cc:
Subject:Can mysql execute this ? how can i do this ?
Is this possible
"select nome from categorias where
If you have id_categoria in both tables why don't you use join?
Try this:
select nome from categorias inner join categoriamembro
on categorias.id_categoria=categoriamembro.id_categoria
where id_membro=1807
[]s
Anderson Pereira Ataides
Em Qui 06 Fev 2003 00:31, you wrote:
> Is this possible
>
> "
Narciso,
NMR> "select nome from categorias where id_categoria in (select id_categoria
NMR> from categoriamembro where id_membro=1807)"
MySQL supports subselects starting with version 4.1. AFAIK there are
no binary distributions available for 4.1, so you either have to
compile it yourself or wait