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

>>This code was giving me an error, What's wrong with it?
>>
>>

SQLEXEC(lnHandle, "SELECT TAlias1.PIF_NAME, TAlias2.PIF_ID FROM CLIENTS AS TAlias1 INNER JOIN PAYMENTS AS TAlias2 ON TAlias1.PIF_ID = TAlias2.PIF_ID", "CPAY")

>>
>>Thanks.
>
>
>You don't use AS to create a new table name, AFAIK, only for fields, e.g.
>

>select Field1 as NewField1, Field2 as NewField2 from Table1 T1 inner join ...

>
>So, your syntax may have been wrong.