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