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