Select * ; FROM jbfic!documentoscabcli a ; INNER JOIN jbfic!documentoslincli b ; on a.c_tipodoc = b.c_tipodoc; AND a.c_armazem = b.c_armazem; AND a.c_cod_ser = b.c_cod_ser; AND a.c_numdoc = b.c_numdoc; AND BETWEEN(a.c_tipodoc+a.c_armazem+a.c_cod_ser+a.c_numdoc, lcP, lcU) ; LEFT OUTER JOIN jbfic!documentos c ; ON a.c_codcli = d.c_codigo ; LEFT OUTER JOIN jbfic!clientes d ; ON a.c_tipodoc = c.c_codigo ; LEFT OUTER JOIN country e ; ON a.c_countryid = e.c_countryid ; ORDER BY a.c_tipodoc, a.c_armazem,; a.c_cod_ser, a.c_numdoc; into cursor factPS: Add FORCE if needed.