Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 28 Oct 2003 @ 07:25:52 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Is the following correct ?
From:   Narayan Murthy K S

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;

sel A.a,B.a from t2 A, t2 B where A.b=B.b;

*** Query completed. No rows found.
*** Total elapsed time was 1 second.

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.


  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023