SELECT BookName, BookAuthor, PubName, BookStyle, Subject, BookLanguage, CASE BookState WHEN 1 THEN '借出' WHEN 2 THEN '在库' WHEN 3 THEN '已预约' END AS Expr1 FROM BookInfo要加上引号
最后加 else '' end
