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