Retorna qual a maior data dentre as tabelas envolvidas…

SELECT MAX(ALU_DTA_NASC)
FROM ( SELECT * FROM ALUNOS0  UNION ALL
       SELECT * FROM ALUNOS1  UNION ALL
       SELECT * FROM ALUNOS2)