Do Inner Selects work in MySQL

[Anon]

Hello,

I am trying to move a client from Ms SQL to MySQL; however I have a big problem.

There is this select sentence that should be carried out for a specific task and it works fine in MsSQL. I tried it in MySQL but to no avail!

The SQL sentence I am trying to run is something as below:

SELECT field1, field2, (SELECT field4 FROM table4 WHERE ...) as field3 FROM table_name WHERE ....

The inner select in paranthesis does not work and give a syntax error. I am told that this works in Oracle too and that it is in the ANSI SQL standard.

I am desperate to find a solution. Any help would be highly appreciated.

Thanks...

[[deleted]]

MySQL does not do subqueries, use PostgreSQL instead.

[alicetiner]

Would you know if MySQL 4.0 supports this feature?

It's a shame for MySQL, isn't it?

[[deleted]]

4.0 doesn't support it.

MySQL has a history of announcing that they will soon support a lot of things, but they never deliver. It took from v1.0 to 4.0 to get 'union', and they rely on InnoDB for transactions and row-level-locking.

Yes it is a shame, because it makes MySQL useless for anyone who's used to using a 'proper' database, and newbies get completely the wrong idea of what databases can do.