Try this:
select key_col, min(name), max(date_col)
from my_table
group by key_col ;
You could use max(name) instead of min(name) also, although
since the names can be misspelled, I don't see why it would matter
which name is displayed.
s.s.
On Wed, 30 Jan 2002 21:36:04
On Wed, 30 Jan 2002 08:21:49 +1000, you wrote:
>I tried this on an existing table using a char(50) column with 956 entries,
>of which I have 1 valid entry and 954 NULL values. I have 2 records returned
>1 = valid entry, 1 = NULL and mysql did not crash.
>Is it only when you are using temporary ta