IS

WHERE

ON

FROM

SELECT * FROM tab T LEFT OUTER JOIN soft_del SD ON T . ID = SD . ID WHERE SD . ID IS NULL