hello
I’ve got table A, B and AB that is a relational table of table A and B. In table AB I’ve got the following columns in:
IdAb
Date
FK_A
FK_B

I have several rows in table like this:

1, 2004, 1, 1
2, 2005, 1, 2
3, 2003, 2, 1

Now to my question;
How do I write my SQL-question to get the latest date for each FK_A like this:

2, 2005, 1, 2
3, 2003, 2, 1

Thanks in advance

Matte

use order by 'Date Concatenation' [Asc|Desc]


Ahmed Ali
Software Developer

Hi Matte,

Use this.

Cheers!

_________________________
- Vijay G
Strive for Perfection