Hi all, this is hurting my head.
Can anybody point me in the right direction?

TABLE_A
TA_ID
TA_YEAR

TABLE_B
TA_ID
TB_VALUE

There is a one to one between TABLE_A and TABLE_B on TA_ID
TB_VALUE can re-occur.

So to different TA_ID's may have the same TB_VALUE

I want to select the TA_ID with the highest TA_YEAR and the TA_ID with the lowest TA_YEAR in one record for records that match on TB_VALUE

So
TABLE_A
TA_ID TA_YEAR
1 2003
2 2004
3 2005

TABLE_B
TA_ID TB_VALUE
1 81
2 43
3 81

The query would return a recordset
TA_ID_High TA_ID_LOW TB_VALUE
3 1 81

I cant get my head around the query at all.......
Many thanks for your time to read this. any help would be appreciated.


======================================
They say, best men are molded out of faults,
And, for the most, become much more the better
For being a little bad.
======================================

__________________
======================================
"They say, best men are molded out of faults,
And, for the most, become much more the better
For being a little bad."
--Shakespeare
======================================

select x = min(A.TA_Year), y = max(A.TA_year), B.TB_Value
from Table_A A
inner join Table_B B on A.TA_ID = B.TA_ID

Have not tested it but I think this is the direction your going for.

Thanks heaps Rob,
That does look like the right thing.
I'll give it a try.

======================================
They say, best men are molded out of faults,
And, for the most, become much more the better
For being a little bad.
======================================