<div>
Which order do you need? The latest order? This query will return you the latest order:<br />

<pre><code id="code-20-40242618-1">SELECT * FROM CUSTOMERS A
  LEFT OUTER JOIN 
  ORDERS O ON A.CUST_ID = O.CUST_ID 
    AND O.ORDER_ID = (SELECT MAX(ORDER_ID) FROM ORDERS WHERE CUST_ID = O.CUST_ID)</code></pre>
</div>


Which order do you need? The latest order? This query will return you the latest order:


SELECT * FROM CUSTOMERS A
  LEFT OUTER JOIN 
  ORDERS O ON A.CUST_ID = O.CUST_ID 
    AND O.ORDER_ID = (SELECT MAX(ORDER_ID) FROM ORDERS WHERE CUST_ID = O.CUST_ID)

<div>
order by most current ORDER DATE.<br />
So I need the customer and most current order
</div>


order by most current ORDER DATE.
So I need the customer and most current order

<div>
<div class="content wysiwyg-content">
Hi<br />
I have a Customer tables and an Orders table.<br />
<br />
How can I write a query that will return just 1 record from the Orders table <br />
<br />
SELECT * FROM CUSTOMERS A<br />
&nbsp; LEFT OUTER JOIN ORDERS ON A.CUST_ID = ORDERS.CUST_ID
</div>
</div>


Hi
I have a Customer tables and an Orders table.

How can I write a query that will return just 1 record from the Orders table 

SELECT * FROM CUSTOMERS A
  LEFT OUTER JOIN ORDERS ON A.CUST_ID = ORDERS.CUST_ID

Help with LEFT OUTER JOIN

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.