Prueba asi:
Código sql:
Ver original[COLOR=black][FONT=Verdana]
[COLOR=black][FONT=Verdana]SELECT t1.nombre, t2.nombre pila
FROM actores AS t1, actorfil AS t2, film AS t3
WHERE (t1.codactores=t2.codactor AND t2.codfilm=t3.codpel AND
[COLOR=black][FONT=Verdana]t3.taquilla IN (SELECT top 2 taquilla FROM film AS t1 ORDER BY taquilla DESC)
[/FONT][/COLOR]
[/FONT][/COLOR]
[/FONT][/COLOR]