LISTING 1: Example of Using ANSI Syntax to Cascade an Outer Join

USE pubs

-- ANSI-standard syntax

SELECT a.au_fname,
   a.au_lname,
   p.pub_name,
   s.zip
FROM authors a
   LEFT OUTER JOIN publishers p
      ON a.city = p.city
   LEFT OUTER JOIN stores s
      ON p.pub_name = s.stor_name

-- Old syntax; results in an error

SELECT a.au_fname,
   a.au_lname,
   p.pub_name,
   s.zip
FROM authors a,
   publishers p,
   stores s
WHERE a.city *= p.city
AND p.pub_name *= s.stor_name