>
>
> 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 id_categoria in
>
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
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
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 (
Hi Andreas,
> I'm just getting started with mysql so please bear with me. =8-}
> I do a 3 table query like:
> SELECT a.x, b.y, c.z
> FROM a, b, c
> WHERE a.b_fk = b.id AND a.c_fk = c.id;
> That works so far.
> In c can be rows which aren't active anymore.
> There is a good_from and a good_until
Hi
I'm just getting started with mysql so please bear with me. =8-}
I do a 3 table query like:
SELECT a.x, b.y, c.z
FROM a, b, c
WHERE a.b_fk = b.id AND a.c_fk = c.id;
That works so far.
In c can be rows which aren't active anymore.
There is a good_from and a good_until DATETIME field which
You have written the following:
[snip]
> I have a file(transfile) that has 2 fields(cust# and item#)
>
> CUST# ITEM#
> 1 '12a'
> 1 '13a'
> 2 '12a'
> 3 '13a'
> 4 '15a'
>
> If I want to select customers tha
: "Smith, Mike" <[EMAIL PROTECTED]>
> To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
> Subject: RE: How can I do this SQL query
> Date: Thu, 23 May 2002 15:33:05 -0400
>
> How can I do this SQL query
>
> I have a file(transfile) that has
; If I want to select customers that have ordered item '12a' but not '13a'
> How can I do this?
>
> I want to end up with a result of only customer 2 in this case.
Maybe something like this:
SELECT cust
FROM
transfile AS t1
LEFT JOIN transfile AS t2 ON
How can I do this SQL query
I have a file(transfile) that has 2 fields(cust# and item#)
CUST# ITEM#
1 '12a'
1 '13a'
2 '12a'
3 '13a'
4 '15a'
If I want to sel
Hi,
I have four table that have common fields like: date, destinazione and
price.
I what to create a temporary table with all four fields from four tables,
what would be the correct sql syntax.
TIA
Adrian
-
Be
1.parentid
> WHERE ((families.parentid)=0);
>
> > -Original Message-
> > From: Johannes Pretorius [SMTP:[EMAIL PROTECTED]]
> > Sent: 01 February 2001 15:13
> > To: MySQL
> > Subject: Re: How can I do this ???
> >
> >
> > Yes that is
P:[EMAIL PROTECTED]]
> > Sent: 01 February 2001 15:13
> > To: MySQL
> > Subject:Re: How can I do this ???
> >
> >
> > Yes that is true but what I want to get at is. Like I want to get
> > all Childs of the Parents. But NOT the Parents. Meaning if
; From: Johannes Pretorius [SMTP:[EMAIL PROTECTED]]
> Sent: 01 February 2001 15:13
> To: MySQL
> Subject: Re: How can I do this ???
>
>
> Yes that is true but what I want to get at is. Like I want to get
> all Childs of the Parents. But NOT the Parents. Meaning if the
&g
OBJID = 1
>
> :)
>
> - Original Message -
> From: Johannes Pretorius <[EMAIL PROTECTED]>
> To: MySQL <[EMAIL PROTECTED]>
> Sent: Thursday, February 01, 2001 4:43 PM
> Subject: How can I do this ???
>
> > Hi there
> > 0---0
> > Sorry for stupid Q
&g
According to your question it could be done as simple as
select * from People where PARENT_ID = 1 or OBJID = 1
:)
- Original Message -
From: Johannes Pretorius <[EMAIL PROTECTED]>
To: MySQL <[EMAIL PROTECTED]>
Sent: Thursday, February 01, 2001 4:43 PM
Subject: How c
Hi there
0---0
Sorry for stupid Q
but I have the following Table named People
OBJID -> int(11) not null auto_increment
NAME -> varchar(25)
PARENT_ID -> int(11)
Now if my data is as follows
OBJID | NAME | PARENT_ID
---
1
18 matches
Mail list logo