create view book_borrow as
select bk.ISBN, bk.author, bk.Title, br.LName, br.ID
from dbo.book bk,
     dbo.borrow br
where bk.isbn=br.isbn