>>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)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.