LIST FILE.NAME STATUS DATE
001 A 02/18/2009
B
C 02/18/2009
STATUS equals A, B, and C.
There are DATEs for A and C, but not B.
-- Louie In Seattle
Yes, Louie understands the issue, I should have given an example before.
The status and dates are associated with each other. In the real world, we
don't use A, B and C. When a record is created, a list of desired status
codes are written into the record, with some other associated valued. They
might be something like "Open, Reviewed, Closed, Filed" with another 5
fields associated with each status code. Examples (dates, names,
resolution, etc). It is important to track the details of what happened and
when, so we keep the details in these associated fields.
So the question really might be stated in English
"Give me a list of all cases that have been opened, but not yet reviewed"
I apologize for the confusion caused by my not giving enough information
before.
Noah Hart
--
View this message in context:
http://www.nabble.com/Need-help-with-SELECT-limiting-MV-tp22063800p22106540.html
Sent from the U2 - Users mailing list archive at Nabble.com.
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
