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

-- rowid is inserted into soft_del when a deletion takes place