Bonnie,

SELECT * FROM mytable mt1
  WHERE NOT EXISTS ( SELECT * FROM mytable mt2 
        WHERE mt2.FK = mt1.FK and mt2.date > mt1.date)
-- or
SELECT * FROM mytable mt1
  WHERE date = ( SELECT MAX(date) FROM mytable mt2 
        WHERE mt2.FK = mt1.FK )

>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,
>~~