469,082 Members | 1,215 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,082 developers. It's quick & easy.

Subqueries not working

Been banging my head against the wall with subqueries. Even simple stuff
like this fails:

SELECT CompanyName FROM tblcompanies
WHERE CompanyName IN (SELECT HostName FROM tblhosts)

Am I missing something blindingly obvious, or is MySQL just playing silly
buggers?

Running v 4.0.18 btw on Windows Server 2003

Any help would be appreciated...

Thanks,

Pete
Jul 19 '05 #1
6 1572
pete wrote:
Been banging my head against the wall with subqueries. Even simple stuff
like this fails: Running v 4.0.18 btw on Windows Server 2003


Subqueries are supported from version >= 4.1

http://www.mysql.com/doc/en/ANSI_diff_Subqueries.html
Jul 19 '05 #2
pete wrote:
Been banging my head against the wall with subqueries. Even simple stuff
like this fails: Running v 4.0.18 btw on Windows Server 2003


Subqueries are supported from version >= 4.1

http://www.mysql.com/doc/en/ANSI_diff_Subqueries.html
Jul 19 '05 #3
pete wrote:
Been banging my head against the wall with subqueries. Even simple stuff
like this fails: Running v 4.0.18 btw on Windows Server 2003


Subqueries are supported from version >= 4.1

http://www.mysql.com/doc/en/ANSI_diff_Subqueries.html
Jul 19 '05 #4

"Aggro" <sp**********@yahoo.com> wrote in message
news:Kw***************@read3.inet.fi...
pete wrote:
Subqueries are supported from version >= 4.1

http://www.mysql.com/doc/en/ANSI_diff_Subqueries.html


Damn. 4.1 is still in alpha too. Can't afford to be running a mission
critical app on alpha software :-(

Thanks for the heads-up.

Pete
Jul 19 '05 #5

"Aggro" <sp**********@yahoo.com> wrote in message
news:Kw***************@read3.inet.fi...
pete wrote:
Subqueries are supported from version >= 4.1

http://www.mysql.com/doc/en/ANSI_diff_Subqueries.html


Damn. 4.1 is still in alpha too. Can't afford to be running a mission
critical app on alpha software :-(

Thanks for the heads-up.

Pete
Jul 19 '05 #6

"Aggro" <sp**********@yahoo.com> wrote in message
news:Kw***************@read3.inet.fi...
pete wrote:
Subqueries are supported from version >= 4.1

http://www.mysql.com/doc/en/ANSI_diff_Subqueries.html


Damn. 4.1 is still in alpha too. Can't afford to be running a mission
critical app on alpha software :-(

Thanks for the heads-up.

Pete
Jul 19 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Daniel Elliott | last post: by
2 posts views Thread by Kevin | last post: by
2 posts views Thread by orin | last post: by
debasisdas
reply views Thread by debasisdas | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.