Help on SQL query

From: Miguel Camba <M.CAMBA_at_terra.es>
Date: Sat, 19 Jan 2002 00:51:45 GMT
Message-ID: <3c48c2d3.1826138_at_news.terra.es>

[Quoted] [Quoted] I have an Oracle 8.1.6 table PURCHASEORDERST

CHANGEDATE	DATE
PURCHASEORDER	VARCHAR2(20)
STATUS		VARCHAR2(2)

Primary key on (CHANGEDATE, PURCHASEORDER)

When purchase order staus change a trigger insert a record in PURCHASEORDERST table.

V1, v2 are valid status; N1, N2 are not valid status.

I got a date like a parameter; I need know if the last status before the parameter is a valid status or not.

Thanks. Received on Sat Jan 19 2002 - 01:51:45 CET