Hi Bonnie,

Try

select PK, FK, Date from (select Date, PK, FK, row_number() 
OVER (partition by FK order by Date DESC) as rn) MaxDates where rn = 1

>I have two tables, one with a date, PK and a FK to the second table. I need to select the latest date and the two keys for every group of FK's. If my data is this:
>

>Date         PK          FK
>1/1/2001     1           1
>1/5/2002     2           1
>2/2/2001     3           1
>6/6/2005     4           2
>1/1/2005     5           2
>

>Then I'd like my output to look like this:
>

>Date         PK          FK
>1/5/2002     2           1
>6/6/2005     4           2
>

>I'm having trouble coming up with a query to do this. Any ideas?
>
>TIA,
>~~Bonnie