MySQL 5 is latest version. Please read if your version is older than 4.1

[guelphdad]

The lastest full production release of MySQL is version 5.

Some hosts do not support version 5 yet but most should be supporting version 4.1.

If your version is older than 4.1 please note that in any new threads you start. This is because older versions do not support things like GROUP_CONCAT and subqueries among other things.

If you happen to still be on MySQL 3.x then you won't even have the ability to use UNION.

If you note that you are using an older version, then when someone is composing a solution to help you, they will give you a version that you can use on your particular release of MySQL.

Subqueries can be re-written as joins and in place of a UNION you may create a temporary table and then query results from it for instance.

[malfist]

The people I program for (a university on the bleeding edge of technology) is still using MySQL 3.23, the oldest version MySQL supplies documentation for.

[annaharris]

I am using newer version (mysql 5) and i can use UNION as well as group contact through this new specification.