Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 13 Dec 2007 @ 11:27:41 GMT

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

Subj:   Re: A question on Left Join
From:   Victor Sokovin

  I get back zero rows. Am I missing something? Irrespective of how the plan is formed, should it not return 45 rows atleast? Request you to please opine.  

Your expectation is correct so if you submit the query exactly as you presented it here for us (with real table names) you should at least get 45 rows.

My opinion? Stop using the database giving you incorrect answers. Databases are only worth using if they provide correct answers.



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