SQL Three table JOIN old-style

SQL

Download (.zip)

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

SQLCorrelated subquery with derived table Creat table nc heap nodupes Creat table nc nodupes
SQLCreat table nc overlap Create table clustered dupes Create table clustered nodupes
SQLCreate table waitstats Cursor vs join Delete from clustered table
SQLFull Outer JOIN old-style vs ANSI Full Outer JOIN JOINs with dummy rows
SQLLocks for table creation Old style outer joins Outer JOIN queries