Hi Nadya,

I always alias no matter how many tables are part of the SQL. I do this for a couple of reasons.

1. The code is easier to read ( IMO ).
2. Maybe one day you'll need to modify the SQL to cater for extra tables.

Regards,
Gavin...

>>It's bad SQL to get rid of aliases. It takes up no overhead and is esier to read.
>>
>
>Well, I guess it's just a personal preference. I don't use aliases, if field names are unique or I use one table. One additional reason for this, that we use special application for Query, so the less characters we put in the field (which would be then evaluated), the better.
>
>Anyway, disregard this part of advice, then.
>
>>>It's obviously better to prepare all constants before SQL than caluclating them in SQL for each record. So, the third example is the best here. Also I would get rid of aliases, since you're using only one table in your SQL.