Sorry Rudy, I wasnt clear
The numbers are all mandate numbers starting at 1 and increasing in sequence
These numbers are distributed by the existing system into two tables, a property table and a buyers table. A mandate exists for each property that is being sold and for each buyer who has commissioned the agency to search for a house on their behalf. Hence the two tables.
To further complicate the property table, on a change of selling price the mandate has to be reissued and the old one is annulled. The system currently deals with this by issuing a new mandate number for the property and placing the old mandate number into another field just to keep a record of it.
What I need to do is to produce a table that collates all these numbers, property mandates, buyers mandates and old property mandates, and display them in mandate order.
Lots of other fields in both tables but the ones that concern this question are
Hope thats clearer
edit: in an ideal world the mandate numbers would have their own table and then be referenced to the property or buyers id, but the system is already in place and this requirement is an add on to an add on, if its too complicated to do, or even not do-able I'll have to rethink the method of producing this data and sort the table rows using PHP.