to uz asi jednym prikazom neurobis...

musis si urobit view, ktore ti da pre kazde ID pocet riadkov

CREATE VIEW V_PRIADKOV
AS
SELECT TAB1_ID, COUNT(*)
FROM TAB2
GROUP BY TAB1_ID;

SELECT *
FROM TAB1 T1
LEFT JOIN TAB2 T2
ON T1.ID = T2.TAB1_ID
LEFT JOIN V_PRIADKOV PR
ON PR.TAB1_ID = T1.ID
WHERE T2.CAS = (SELECT MAX(CAS) FROM TAB2 WHERE TAB1_ID = T1.ID)