e perche' no...

codice:
select *
from tab_1
inner join tab_2 ON  tab_2.id = tab_1.mark_id
where ... pincopallo blabla
order by tab_2.name