>Hi Naomi,
>
>Im thinking that word "AS", yes your correct should only be use when aliasing a field name.
>
>But I found that sample on VFP9 help.
>

>CLOSE ALL
>CLOSE DATABASES
>OPEN DATABASE (HOME(2) + 'Data\TestData')
>SELECT TAlias1.company, TAlias2.order_ID ;
>   FROM customer AS TAlias1 ;
>   INNER JOIN orders AS TAlias2 ;
>      ON TAlias1.cust_id = TAlias2.cust_id ;
>   ORDER BY TAlias1.company ASC
>
>

>

I've never used this syntax, that's why it looked wrong to me. But I may be wrong myself, need to try once I finish working on something else.

Thanks.