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
>
*******************************************************
Save a tree, eat a beaver.
Denis Chassé