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