Tera-Tom Genius Series - Kognitio Architecture and SQL

Chapter 8 – Join Functions

“An invasion of Armies can be resisted, but not an idea whose time has come.”

- Victor Hugo

A Two-Table Join Using Traditional Syntax

A Join combines columns on the report from more than one table. The example above joins the Customer_Table and the Order_Table together. The most complicated part of any join is the JOIN CONDITION. The JOIN CONDITION is which Column from each table is a match. In this case, Customer_Number is a match that establishes the relationship, so this join will happen on matching Customer_Number columns.

A two-table join using Non-ANSI Syntax with Table Alias

A Join combines columns on the report ...