CROSS/OUTER APPLY in MySQL
<p>I need to use CROSS APPLY in MySQL (EC2 RDS MySQL instance).
Looks like MySQL doesn't recognise the CROSS APPLY Syntax. Can someone help me please?</p>

<p>Here's the query.</p>

<pre><code>SELECT ORD.ID
    ,ORD.NAME
    ,ORD.DATE
    ,ORD_HIST.VALUE
FROM ORD
CROSS APPLY (
    SELECT TOP 1 ORD_HISTORY.VALUE
    FROM ORD_HISTORY
    WHERE ORD.ID = ORD_HISTORY.ID
        AND ORD.DATE &lt;= ORD_HISTORY.DATE
    ORDER BY ORD_HISTORY.DATE DESC
    ) ORD_HIST
</code></pre>