sorry,

SELECT A.COD, A.FLAG, B.AREA, B.NUM_ID
FROM TAB A, TAB1 B
WHERE A.ID=B.ID
AND (FLAG=1 OR (FLAG=2 AND COD = 'N'))