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

Related snippets