Thank you William.
>>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?
>
>To do a Join you need to identify a table. The Select MAX(Date... builds the table but he identifies it as Tbl1 (like a temnporary table name).
>
>
>>
>>
>>
>>>>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é