mozes este takto:
SELECT T1.*, MAX(T2.CAS) AS CAS
FROM TAB1 T1
LEFT JOIN TAB2 T2
ON T1.ID = T2.TAB1_ID
GROUP BY T1.*;samozrejme T1.* budes musiet nahradit normalnym zoznamom stlpcov T1.stlpec1, T1.stlpec2...etc. aj v group by klauzule
pripadne este:
SELECT *
FROM TAB1 T1
LEFT JOIN TAB2 T2
ON T1.ID = T2.TAB1_ID
WHERE T2.CAS = (SELECT MAX(CAS) FROM TAB2 WHERE TAB1_ID = T1.ID)