USE pubs
GO
SELECT 
'Author'=RTRIM(au_lname) + ', ' + au_fname,
'Title'=title
FROM authors AS A JOIN titleauthor AS TA 
    ON A.au_id=TA.au_id          -- JOIN CONDITION
JOIN titles AS T
    ON T.title_id=TA.title_id    -- JOIN CONDITION
WHERE A.state <> 'CA'
ORDER BY 1
Published in: SQL
Download

Related snippets