sure and thanks for viewing,

my original query

Select car_model,max(year) from table auto where car_model='cherokee' group by car_model

results

cherokee 2001

heres what i get when i add ext_color

Select car_model,max(year),ext_color from table auto where...

yes that was what i saw in the tutorial, but the issue i face is when you add color to the group by it no longer respects my max...

thanks sqlbill,

Select car_model,max(year) from table auto group by car_model

here is what i came up with and it works great. one last question if i added a column to this...

thanks for the point in the right direction i'll update here once i get the query working

nick

that worked great thanks for the tip

perfect that worked like a charm

thank you for your help

the table names are

tbl_a , tbl_b

and the columns are

LINK_100, 100

LINK_101, 101