I am executing the following to compare a clog that is within 2 different tables.
from CMS_MAIL a,CMR_MAIL b
where b.ORDERNO = '4'
and a.JOBNO = '6';
I need the query to output if the same = 0 if different = 1
Not sure how to do this.