The Coding Error - Teradata Database

SQL Data Manipulation Language

Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-10-06
dita:id
B035-1146
lifecycle
previous
Product Category
Teradata® Database

The Coding Error

The SELECT statement errs by placing all of the selection criteria for the query in the ON clause. The ON clause should only include selection criteria for the inner table in the outer join, that is, the criteria that define the nullable nonmatching rows for the outer join.

Selection criteria for the outer table (the customer table in this case) in the outer join must be placed in the WHERE clause.