>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?
>

As William said, it identifies the table. For completeness, it's called a "local alias." There are other reasons you assign a local alias in a query, such as when a query contains two instances of the same tabel.

Tamar