Hi

I´m having problems with a query, when the query have many "joins" and I
place the clause "order by" the application freeze. In IBExpert freeze too.
The query compiles, but does not execute. Somebody had a similar problem,
can give some tip?
The Query is this:

SELECT * FROM Pasta
LEFT JOIN Processo ON Pasta.idPasta = Processo.idPastaProc
LEFT JOIN Jurisdicao ON Jurisdicao.idJurisdicao = Processo.idJurisdicao
LEFT JOIN Pessoa PessoaCliente ON Pasta.idPesCliPrinc =
PessoaCliente.idPessoa
LEFT JOIN Pessoa PessoaJuizo ON PessoaJuizo.idPessoa =
Processo.idPessoaJuizo
LEFT JOIN Pessoa PessoaContr ON PessoaContr.idPessoa =
Processo.idPesAdversoPrinc
LEFT JOIN TipoAcao ON TipoAcao.idTipoAcao = Processo.idTipoAcaoProc
RIGHT JOIN Compromisso ON Pasta.idPasta = Compromisso.idPastaCompromisso
LEFT JOIN Pessoa PessoaCompr ON PessoaCompr.idPessoa =
Compromisso.idPessoaCompromisso
ORDER BY pasta.idpasta

thanks for help
Rafael Colucci