[MYSQL] ordinamento su altra tabella

[piero.mac]

SELECT a.nome
FROM tab1 a
left join tab2 b
on b.id = a.id
order by b.importo