09-08-2014 09:43 PM
I am getting a weired output while using the 'except all' command. I have (A join B) as source and C as target.
(A join B) has same number of records as in C
if I do a 'except all' between C and (A join B) I get no records
but when I do 'except all' between (A join B) and C I get 37 records. And these records are actually not seen in (A join B).
Can anybody take me out of this problem?
09-09-2014 12:39 PM
here is the code-
create table TEST_RESULT as
from MPTST031_UWS_POL A, CSTST061_UWS_CB_CV B
where A.POL_N = B.POL_N
select count(*) from TEST_RESULT;