Exactly. Thank you Borislav

Another question

INNER JOIN (SELECT MAX(Date) AS Date FROM Table1) Tbl1

I don't understand the tbl1 at the end. Could you please explain that sentence?



>>Table 1: fields are Date, and Identification
>>
>>Table 2: fields are Date, Identification, Amount
>>
>>How would I build my SQL so that I can get all the amounts from table 2 based on the Id that I got from table 1 for the last date in table 1
>>
>>Table 1
>>===========
>>2008/11/18 24
>>2008/11/19 25
>>
>>Table 2
>>===========
>>2008/11/18 24 75
>>2008/11/18 24 55
>>2008/11/19 25 12
>>2008/11/19 25 40
>>2008/11/19 25 22
>>
>>So the result would be
>>
>>2008/11/19 25 12
>>2008/11/19 25 40
>>2008/11/19 25 22
>>
>>I've been playing a bit but it does'nt work
>>
>>perhaps with a union? I just thought of that
>
>How about:
>

>SELECT Table2.*;
>FROM Table2;
>INNER JOIN (SELECT MAX(Date) AS Date FROM Table1) Tbl1;
>           ON Table2.Date = Tbl1.Date;
>INTO CURSOR crsTest
>BROWSE NORMAL
>