>Hi all,
>
>I try to do this select and i get an error unrecognize phrase/keyword.
>
>SELECT * ;
>FROM DOCUMENTOSCABCLI A, DOCUMENTOSLINCLI B;
>WHERE A.C_TIPODOC+A.C_ARMAZEM+A.C_COD_SER+A.C_NUMDOC=B.C_TIPODOC+B.C_ARMAZEM+B.C_COD_SER+B.C_NUMDOC ;
>BETWEEN 1 AND 5 ;
>INTO CURSOR DOCUMENTOS
>
>Thank's in Advance
>
>João Batista

Try this, but this is not optimized.

SELECT * ;
FROM DOCUMENTOSCABCLI A, DOCUMENTOSLINCLI B;
WHERE A.C_TIPODOC+A.C_ARMAZEM+A.C_COD_SER+A.C_NUMDOC = ;
B.C_TIPODOC+B.C_ARMAZEM+B.C_COD_SER+B.C_NUMDOC ;
AND BETWEEN(A.C_TIPODOC+A.C_ARMAZEM+A.C_COD_SER+A.C_NUMDOC, 1, 5) ;
INTO CURSOR DOCUMENTOS