02:31
To:mysql
cc:
Subject:Can mysql execute this ? how can i do
this ?
Is this possible
select nome from categorias where id_categoria in
(select id_categoria
from categoriamembro where id_membro=1807)
in MySQL
Thks
[MsR
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 a
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
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
Is this possible
select nome from categorias where id_categoria in (select id_categoria
from categoriamembro where id_membro=1807)
in MySQL
Thks
[MsR]
-
Before posting, please check:
http://www.mysql.com/manual.php