Hi, do like Helen suggested, but use a slight twist:

Select Cliente.Nome
From Cliente
JOIN Cliente_Mailing
ON
Cliente.id_cliente=Cliente_Mailing.id_cliente
WHERE
Cliente_Mailing.id_mailing between 8 and 9
Order by CLIENTE.nome

if you have an index on (id_mailing, <pk>) in addition to id_cliente that
should be as fast as you get it.

Set