Archives of the TeradataForum

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

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

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>>