Consulta 2 tablas distintas mysql

[protoameeba]

Es que si pongo esto:


SELECT votos FROM SELECT votos FROM album_1 UNION ALL SELECT votos FROM album_2 ORDER BY votos DESC LIMIT 3


me da este error:


#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT votos FROM album_1 UNION ALL SELECT votos FROM album_2 ORDER BY votos ' at line 1