select b.seq,a.seq,b.title
from
yb033 a full join yb003 b on a.vseq_yb033 = b.seq
where
NVL(a.isvalid,0) <> NVL(b.isvalid,0)
and a.ctime > '20190101'
and b.ctime > '20190101
用NVL对空值进行处理即可例子:select b.seq,a.seq,b.titlefrom yb033 a full join yb003 b on a.vseq_yb033 = b.seqwhere NVL(a.isvalid,0) <> NVL(b.isvalid,0) and a.ctime > '20190101' and b.ctime ...