SELECT	distinct a.AuthorFirst, a.AuthorLast
FROM	author a, wrote w1 
WHERE	(a.AuthorNum = w1.AuthorNum)
AND		(w1.BookCode IN
         	(SELECT b.BookCode
             FROM	book b 
             WHERE	b.Type = 'MYS'
             AND	(b.BookCode IN
         				(SELECT i.BookCode
             			FROM	inventory i, branch br  
            			WHERE	br.BranchName = 'Henry Brentwood' AND i.BranchNum = br.BranchNum
            			)
					)
             )
		)