CREATE VIEW books AS SELECT Book_T( b.ISBN, b.Title, b.Price, Person_T( a.First_Name, a.Last_Name ) ) as Book FROM book_table b, author_table a WHERE b.author_id = a.id;