[sql]
select
t1.company,t0.location
from
Companies t1
,
(select company_id,location from Locations where revision in
(select max(revision) as maxrevision group by company_id)
) t0
where
t0.company_id=t1.id
;
[/sql]

Totally not tested.
Yet, I hope it is of any help.

Dimitar