三表关联查询,用inner join:
关系图;
sql语句:
SELECT [User].name,book.bookName,borrowBook.borrowDate,borrowBook.remarks FROM borrowBook INNER JOIN book on borrowBook.bookNo=book.bookNo INNER JOIN [User] on borrowBook.UserNo=[User].UserNo where borrowBook.UserNo=(select [User].UserNo from [User] where [User].name='李高钢')
查询结果: