USE pubs
GO
SELECT au_id
FROM authors
WHERE au_id IN
(SELECT au_id from titleauthor)