Sample tables (company_id RK companies.id):
How to write an SQL query to select values from the following columns (companies.company, locations.location) where locations.revision value will be the highest for each company

I try
Select distinct companies.company, locations.location from Companies, Locations where companies.id=Locations.company_id ...

How? thanks.

SELECT Companies.id, Locations.location, revision
FROM Companies INNER JOIN Locations ON Companies.id=Locations.id
INNER JOIN
(SELECT C1.id, max(C2.revision) AS maxrevision
FROM Companies C1 INNER JOIN Locations C2 ON C1.id=C2.id GROUP BY C1.id) T2
ON Companies.id=T2.id AND revision=maxrevision
I do this...it works, but if i just want to output the first 2 column, how?
Companies.id, Locations.location only..i only can do if revision is output together with it,.

Please help. thanks.

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
;

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

Dimitar