O'Reilly logo

Netezza SQL by Mike Larkins, Tom Coffing

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 6 – Join Functions

"When spider webs unite they can tie up a lion."

African Proverb

A two-table join using Non-ANSI Syntax

image

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

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