運行看就知道了!!!
USE pubs
SELECT a.au_fname, a.au_lname, p.pub_name
FROM publishers p LEFT OUTER JOIN authors a
ON a.city = p.city
ORDER BY p.pub_name ASC, a.au_lname ASC, a.au_fname ASC
USE pubs
SELECT a.au_fname, a.au_lname, p.pub_name
FROM authors a left OUTER JOIN publishers p
ON a.city = p.city
ORDER BY p.pub_name ASC, a.au_lname ASC, a.au_fname ASC
USE pubs
SELECT a.au_fname, a.au_lname, p.pub_name
FROM publishers p right OUTER JOIN authors a
ON a.city = p.city
ORDER BY p.pub_name ASC, a.au_lname ASC, a.au_fname ASC
USE pubs
SELECT a.au_fname, a.au_lname, p.pub_name
FROM authors a right OUTER JOIN publishers p
ON a.city = p.city
ORDER BY p.pub_name ASC, a.au_lname ASC, a.au_fname ASC
