Example 2: Outer Join But Does Not Return the Correct Answer - Teradata Database

Example 2 is a correctly formed outer join, but it neither addresses the question posed nor returns the correct answer.

     SELECT c.custnum, b.monthly_revenue

     FROM sampdb.customer AS c

     LEFT OUTER JOIN sampdb2.revenue AS b ON c.custnum = b.custnum

     AND  c.district ='K'

     AND  b.data_year_month = 199707

     AND (c.service_type ='ABC'

     OR   c.service_type ='XYZ')

     ORDER BY 1;

This query returns 17713502 rows.