Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 26 Feb 2009 @ 21:48:20 GMT


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


Subj:   Re: Too much time spent on aggregate function
 
From:   frank.c.martinez

Yep, the only query visualization I've ever seen (rather than tables) is a diagram that BI/Query used to use to help people select outer joins. It had a picture of two things that looked like hands with fingers. For a left outer join, it showed something like:

     xxxxx ------
     yyyyy yyyyyy
     zzzzz ------

For a right outer join it showed:

     ----- xxxxx
     yyyyy yyyyy
     ----- zzzzz

And for a full outer join:

     xxxxx -----
     ----- yyyyy
     zzzzz zzzzz

Of course, there was no mention xyzzy. But the diagram did allow people fairly untrained in relational concepts or SQL (which are of course, two different things) to understand what was meant by 'outer'. Otherwise, they got lost in a twisty little maze of passages.


iv



     
  <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: 27 Dec 2016