>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