SQL Three table JOIN
Three table JOIN
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