Hello,

For two tables:

PRODUCTION_ORDER (ID, DUE_DATE, ID_STATUS , OPEN)

STATUS (ID, DATE, STATUS)

The status table stores a history of production order's status.

How can I get the latest status for a production order.


SELECT
 PO.ID, PO.DUE_DATE, S.DATE, S.STATUS
FROM
 PRODUCTION_ORDER PO, STATUS S
WHERE
 OPEN=TRUE AND PO.ID_STATUS=S.ID

But I want only the latest Status.



Thanks in advance,
Juan
--

Juan,

<< How can I get the latest status for a production order. >>

Try this:

SELECT
 PO.ID, PO.DUE_DATE, S.DATE, MAX(S.STATUS) AS STATUS
FROM
 PRODUCTION_ORDER PO, STATUS S
WHERE
 OPEN=TRUE AND PO.ID_STATUS=S.ID
GROUP BY ID, DUE_DATE, DATE

--
Tim Young
Elevate Software
www.elevatesoft.com