io ho provato così ma mi dice errore vicino a From
SELECT Persone.*,clienti* From (
SELECT TOP 10 * FROM (
SELECT TOP 10 *
FROM Persone,clienti
) AS foo
) AS baz

Tu intendevi così?