To: Yen
Cc: [EMAIL PROTECTED]
Subject: Re: Does MySQL support sub queries ?
On Fri, Apr 13, 2001 at 04:02:31PM +0800, Yen wrote:
Does anyone know whether this MySQL support sub queries?
Anyone who has checked the MySQL Manual does.
(Hint: http://www.mysql.com/doc/M/i/Missing_Sub
Thank you Jeremy, these really help!! I can't find the manual :D
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 13, 2001 4:00 PM
To: Yen
Cc: [EMAIL PROTECTED]
Subject: Re: Does MySQL support sub queries ?
On Fri, Apr 13, 2001 at 04:02:31PM +0800
Well I have managed to rewrite alot of my coding from MS SQL in a downward
and more portable style using MySQL and ASP. I too have now hit apon where
I need to have Sub queries on some basic searching of products. Rather than
just telling people "the manual says..." that Sub Selects are
Hi,
Does anyone know whether this MySQL support sub queries?
such as:
select ref from tool1
where detail = 'xxx'
and ref in
(select ref from tool1
where detail='yyy');
No matter it's within the same table or different table. However below is
the error I've got, anyone can help?
ERROR 1064:
On Fri, Apr 13, 2001 at 04:02:31PM +0800, Yen wrote:
Does anyone know whether this MySQL support sub queries?
Anyone who has checked the MySQL Manual does.
(Hint: http://www.mysql.com/doc/M/i/Missing_Sub-selects.html)
Jeremy
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo