CREATE VIEW V_TAB2
AS
SELECT TAB1_ID, MAX(CAS) AS CAS
FROM TAB2
GROUP BY TAB1_ID;
a potom
SELECT *
FROM TAB1 T
LEFT JOIN V_TAB2 V
ON T.ID = V.TAB1_ID;
CREATE VIEW V_TAB2
AS
SELECT TAB1_ID, MAX(CAS) AS CAS
FROM TAB2
GROUP BY TAB1_ID;
SELECT *
FROM TAB1 T
LEFT JOIN V_TAB2 V
ON T.ID = V.TAB1_ID;