Hi Borilav,

You're right, that was a valid SQL statement for MS SQL Server but not with Firebird.



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