Archives of the TeradataForum

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

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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.

Narayan.

	<Prev	Next>		<<First	<Prev	Next>	Last>>