MySQL subqueries...HELP!

Anon

SELECT *
FROM news, edition
WHERE news.data = (SELECT MAX(edition.data))
Is this query supported by MySQL?
If not, can this query be modified? And how?

Thanx in advance...

Anon

Nope. Unfortunately, current versions of mysql (upto 4.0) do not support subqueries (which is the name for what you are trying to do).

If you are using mysql, I'm afraid that you will probably need to pre-read the edition table and store it's max value in a PHP variable.

Cheers

Justin

geo115fr

Despite the fact that mysql does not support subqueries, there is a workaround that you may use if the expected result consists of one row and only one row :

select * from news,edition where news.data=edition.data order by edition.data
desc limit 0,1

Anon

Can this be done with VBSCRIPT?

Giorgio

[deleted]

You can also use MySQL's internal variables, read this:

http://www.hvt-automation.nl/yapf/faq.php?cmd=viewitem&itemid=102

[deleted]

Probably, but why would you ever want to use VBscript in the first place, and why use VBscript if you are writing your scripts in PHP??

Anon

MySQL does not support this, nor does it support joining or selecting from subqueries. If you want this capability, use PostgreSQL.

Chris