takze final...snad
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) OR T2.CAS IS NULL
takze final...snad
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) OR T2.CAS IS NULL