CREATE VIEW [dbo].[AuthorTitles]
AS
SELECT dbo.TitleAuthor.au_id, dbo.Titles.*
FROM dbo.TitleAuthor INNER JOIN dbo.Titles 
ON dbo.TitleAuthor.title_id = dbo.Titles.title_id