--- Russell Horn <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I'm storing data against a bunch of people and want to track how it
> changes. So, I have a person table where everyone has a person ID and
> a
> results table a bit like this:
>
> | personID | classification | date |
> | 1| 0
Russell -
This should basically work for selecting the most recently selected
preference...
SELECT DISTINCT personID, classification FROM results_table ORDER BY date
DESC
On 4/10/06, Russell Horn <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I'm storing data against a bunch of people and want to track
Hi,
I'm storing data against a bunch of people and want to track how it
changes. So, I have a person table where everyone has a person ID and a
results table a bit like this:
| personID | classification | date |
| 1| 0 | 2005-11-10 |
| 2| 3 | 2005-1
