Subqueries not working

[pete]

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

[Aggro]

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

[Aggro]

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

[Aggro]

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

[pete]

"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

[pete]

"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

[pete]

"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