Ok...I have a file (ORDERFIL) that has an order number (ORDNUM), a
status (ORDSTAT), and a sequence number (ORDSEQ). The sequence number
is just a one up number - it's not the row number, and it's not
related to an order. However, it will be in order by status for an
order. For a given order number, I want to get the current status and
the previous status. I was thinking along the lines of a select work
order, and then another select (temporary table?) where I select for
that order number and order by sequence number descending. Does this
make sense? Any ideas?
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.