StmtText                                                                                                                                                                                                                                                                                      
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 
SELECT TOP 1 a.au_lname AS 'AuthorLastName', a.au_fname AS 'AuthorFirstName', 
t.title AS 'Title', t.pubdate AS 'PublicationDate'
FROM dbo.Authors a
INNER JOIN dbo.TitleAuthor ta
	ON a.au_id = ta.au_id
INNER JOIN dbo.Titles t
	ON ta.title_id = t.title_id
WHERE a.state = 'CA'

(1 row(s) affected)

StmtText                                                                                                                                                                      
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 
  |--Top(1)
       |--Nested Loops(Inner Join, OUTER REFERENCES:([ta].[title_id]))
            |--Nested Loops(Inner Join, OUTER REFERENCES:([ta].[au_id]))
            |    |--Index Scan(OBJECT:([pubs].[dbo].[titleauthor].[titleidind] AS [ta]))
            |    |--Clustered Index Seek(OBJECT:([pubs].[dbo].[authors].[UPKCL_auidind] AS [a]), SEEK:([a].[au_id]=[ta].[au_id]),  WHERE:([a].[state]='CA') ORDERED FORWARD)
            |--Clustered Index Seek(OBJECT:([pubs].[dbo].[titles].[UPKCL_titleidind] AS [t]), SEEK:([t].[title_id]=[ta].[title_id]) ORDERED FORWARD)

(6 row(s) affected)