"Kay Cee" <cee.1@osu.edu> wrote in message
news:bei0q6$hs5$1@charm.magnus.acs.ohio-state.edu...
> I'm trying to create an SQL query using a table with two fields. There
are
> multiple date rows in column B associated with each row in column A. I
was
> looking at using the MAX function to retrieve the most current date value
> for each data row in column A, but the MAX function only retrieves a
single
> data row with the most recent date, irrespective of the values in column
A.
> Is there a way around this?

look at how the GROUP BY clause works, it should help you out.

BTW didn't you used to have a sunshine band?


--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************