Archives of the TeradataForum
Message Posted: Tue, 28 Oct 2003 @ 07:25:52 GMT
Is the following correct?
I have a table t2(a int, b int)
I have one row inserted into the table t2 with value (1,null);
Is the output of the following query correct:
BTEQ -- Enter your DBC/SQL request or BTEQ command:
sel A.a,B.a from t2 A, t2 B where A.b=B.b;
*** Query completed. No rows found.
If it is correct why is the behavior so? I do know the reason behind the output of the query by running an EXPLAIN of the query but is this how it should work - if yes, what is the rational behind the same.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|