Hi,
Can someone tell me why this will not work, please
SELECT * FROM tbl1 WHERE column =(SELECT * FROM tbl2 WHERE intcolumn =
15);
(Table and column names changed to protect the innocent, 15 could be a
variable or anything)
I thought this was just a common or garden 'Inner Query'. I
Have a
John Morton writes:
Can someone tell me why this will not work, please
SELECT * FROM tbl1 WHERE column =(SELECT * FROM tbl2 WHERE intcolumn =
15);
That's a subselect, and a search in the manual gave me this
page, which probably has all the info you need:
On Sat, 2001-11-10 at 05:53, John Morton wrote:
Hi,
Can someone tell me why this will not work, please
SELECT * FROM tbl1 WHERE column =(SELECT * FROM tbl2 WHERE intcolumn =
15);
There are no subselects in MySQL (yet). However, they're usually a bad
idea anyway, which is why it's
NOt supported... Yet. Rumor has it sub-selects will be in 4.1
John Morton wrote:
Hi,
Can someone tell me why this will not work, please
SELECT * FROM tbl1 WHERE column =(SELECT * FROM tbl2 WHERE intcolumn =
15);
(Table and column names changed to protect the innocent, 15 could be a
Steve Meyers wrote:
There are no subselects in MySQL (yet). However, they're usually a bad
idea anyway, which is why it's never been such a big rush to get them in.
Sometimes (just sometimes), there is no way to do it except with a subselect.
For instance, we have a table where we get
we can use subselect now with MySQL-Max version.
- Original Message -
From: Steve Meyers [EMAIL PROTECTED]
To: John Morton [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Saturday, November 10, 2001 8:13 AM
Subject: Re: Beginner SQL Question
On Sat, 2001-11-10 at 05:53, John Morton
10:08 AM
Subject: Re: Beginner SQL Question
Steve Meyers wrote:
There are no subselects in MySQL (yet). However, they're usually a bad
idea anyway, which is why it's never been such a big rush to get them
in.
Sometimes (just sometimes), there is no way to do it except with a
subselect
Nguyen Trong Phuc wrote:
we can use subselect now with MySQL-Max version.
I think not. I know it failed with 3.23.43, when I tried it just now
(mysqld-max).
Regarding encrypt(), the manual does say that encrypt() returns NULL on
OSes where the crypt() function is not available. True.
yeah, mysql is compatible for small business with small and simple database.
We can use PostgreSQL for subselect query as a free SQL server, but it's too
slow.
-
Before posting, please check:
http://www.mysql.com/manual.php
