General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only