Consulta NOVATO MSSQL

[Andres95]

La misma sentencia, eliminando subquerys...

Código:

SELECT A.au_lname,A.au_fname,Ti.title 
FROM authors A
INNER JOIN titleauthor Ta 
ON A.au_id = Ta.au_id
INNER JOIN titles Ti 
ON Ta.title_id = Ti.title_id
ORDER BY A.au_lname

Saludos!