Archives of the TeradataForum
Message Posted: Tue, 02 Sep 2003 @ 20:22:50 GMT
<-- Anonymously Posted: Tuesday, September 02, 2003 16:06 -->
What may be causing MINUS ALL to return more rows that NO EXISTS and NOT IN?
select svc_ordno from provgact
*I cannot select prov_act_id because the selects must have the same number of columns.
select svc_ordno, prov_act_id from provgact p
select svc_ordno, prov_act_id from provgact
provgact where svc_ordno is not null = 1737890 rows
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|