O'Reilly logo

Teradata SQL by Tom Coffing, Mike Larkins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 8 - Join Functions

“When spider webs unite they can tie up a lion”

- African Proverb

 

A two-table join using Non-ANSI Syntax

images

  SELECT Customer_Table.Customer_Number, Customer_Name,Order_Number, Order_Total
  FROM Customer_Table,Order_Table
  WHERE Customer_Table.Customer_Number = Order_Table.Customer_Number;

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 means what Column from each table is a match. In this case, Customer_Number is a match that establishes ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required