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

This is perfect valid SELECT:

SELECT *
      FROM Levels AS Test

in SQL Server, but I see that
Jojo use Firebird so they may have a different opinion about this :o)