It doesn't say what is the exact error, next to the code is

Select('CPAY')
BROWSE

The error that was raise is Alias 'CPAY' is not found, so by this, there is something wrong with my SELECT SQL.

BTW, thanks for the sample code but it doesn't also work. I got invalid Token.

TEXT TO lcSQL NOSHOW PRETEXT 15
     SELECT TAlias1.PIF_NAME,
            TAlias2.PIF_ID
     FROM CLIENTS AS TAlias1
     INNER JOIN PAYMENTS AS TAlias2 ON TAlias1.PIF_ID = TAlias2.PIF_ID
ENDTEXT
IF SQLEXEC(lnHandle, lcSQL , "CPAY") < 0
   AERROR(laError)
   MessageBox(laError[1,2])
ENDIF

But this modified code below works.....

TEXT TO lcSQL NOSHOW PRETEXT 15
     SELECT TAlias1.PIF_NAME,
            TAlias2.PIF_ID
     FROM CLIENTS TAlias1
     INNER JOIN PAYMENTS TAlias2 ON TAlias1.PIF_ID = TAlias2.PIF_ID
ENDTEXT
IF SQLEXEC(lnHandle, lcSQL , "CPAY") < 0
   AERROR(laError)
   MessageBox(laError[1,2])
ENDIF

>>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.
>
>And what is the error?
>

>TEXT TO lcSQL NOSHOW PRETEXT 15
>     SELECT TAlias1.PIF_NAME,
>            TAlias2.PIF_ID
>     FROM CLIENTS AS TAlias1
>     INNER JOIN PAYMENTS AS TAlias2 ON TAlias1.PIF_ID = TAlias2.PIF_ID
>ENDTEXT
>IF SQLEXEC(lnHandle, lcSQL , "CPAY") < 0
>   AERROR(laError)
>   MessageBox(laError[1,2])
>ENDIF
>