Radi li nešto poput ovog:
Kôd:
SELECT
f.file_id
, f.name
, f.label
, version
, downloaded
, (select max(version) from ONDIGITA_FILE_VERSION as fv where fv.file_id = f.file_id) as maxversion
FROM ONDIGITA_FILE AS f
LEFT JOIN ONDIGITA_FILE_VERSION AS s USING (file_id)
Order by maxversion desc, version desc
?