SQL Outer JOIN queries
SQL
Download (.zip)
USE pubs GO
-- QUERY 1 SELECT 'Author'= RTRIM(au_lname) + ', ' + au_fname, 'Title'=title FROM (titleauthor AS TA RIGHT OUTER JOIN authors AS A ON (A.au_id=TA.au_id)) FULL OUTER JOIN titles AS T ON (TA.title_id=T.title_id) WHERE A.state <> 'CA' or A.state is NULL ORDER BY 1 GO
--QUERY 2 SELECT 'Author'=RTRIM(au_lname) + ', ' + au_fname, 'Title'=title FROM (titleauthor AS TA FULL OUTER JOIN titles AS T ON TA.title_id=T.title_id) RIGHT OUTER JOIN authors AS A ON A.au_id=TA.au_id WHERE A.state <> 'CA' or A.state is NULL ORDER BY 1
|