I want to get some data, from 2 fields, but I don't want to select distinctly by them

In my tables I have

Table 1:
A B TIME

Table 2:
A B C D E TIME


my select is

select distinct a, max(2.TIME) from 1 , 2, where 1.a = 2.a and 1.TIME > "2008" GROUP by a

The problem I have is I want to get information about 2.b and 2.c from the fields in this select? is there anyway to do it??? thank you.

Dakiar

You are going to have to be more specific. Give some examples of the raw data and what you want to see in the result set.

Andy

Hmm, it was that hard to understand?? I found out how to do it anyway:

select a, b, c from 2, (select distinct a, max(2.TIME) as MAX from 1 , 2, where 1.a = 2.a and 1.TIME > "2008" GROUP by a) as X where X.a = a AND X.MAX = TIME