| Neil Smith [MVP, Digital media] 2007-04-14, 6:57 pm |
| At 03:04 14/04/2007, you wrote:
>Message-ID: <461FB44B.3010302@btinternet.com>
>Date: Fri, 13 Apr 2007 17:48:11 +0100
>From: ioannes <ioannes@btinternet.com>
>Reply-To: ioannes@btinternet.com
>MIME-Version: 1.0
>To: php-db@lists.php.net
>Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>Content-Transfer-Encoding: 7bit
>Subject: ORDERing two UNION queries: Non-Subquery UNION Execution
>
>http://dev.mysql.com/doc/internals/en/select-union.html
You meant to refer to this page :
http://dev.mysql.com/doc/refman/5.1/en/union.html
>Does anyone know what this means? Can it be implemented in the flow
>of php code without explicitly creating temp tables in the database?
>
>My query is like:
>
>$query = "
> (SELECT
> Table.field, [other fields]
> FROM Table [other JOINs]
> ORDER BY Table.field
> )
> UNION
> (SELECT
> Table2.field, [other fields]
> FROM Table2 [other JOINs]
> ORDER BY Table2.field
> )
> ";
>
>and I want the ORDER to apply to the whole UNIONed result.
So, after reading the correct documentation, you'll now know to write
the query as
(SELECT
Table.field, [other fields]
FROM Table [other JOINs]
)
UNION
(SELECT
Table2.field, [other fields]
FROM Table2 [other JOINs]
)
ORDER BY field
Cheers - Neil
|