请教一条sql语句怎么写?

Question

有如下一个单词表(WordList):
Word    NewWord    Book   字段
look       Yes     NCE_1
play       No      NCE_1
while      No      NCE_1
bad        Yes     NCE_1
good       No      NCE_2
new        Yes     NCE_2
old        Yes     NCE_2
take       Yes     NCE_3
ask        No      NCE_3
name       No      NCE_4
title      No      NCE_4
still      Yes     NCE_4
please     Yes     NCE_5
sad        No      NCE_5
happy      No      NCE_5
girl       No      NCE_6
boy        No      NCE_6我要将NewWord=Yes, Book= NCE_1; NCE_3; NCE_5的所有单词选出来. 
我尝试写了一个: sql= select * from WordList where NewWord='Yes' and (Book=NCE_1 or Book=NCE_3 or Book=NCE_5)
但是不行.请教该怎么写?

Answer 1

select * from tableName where NewWord='yes' and Book in (select Book from TableName)

Answer 2

SELECT * FROM WordList
WHERE NewWord='Yes' 
AND Book IN ('NCE_1','NCE_3','NCE_5')

Answer 3

SELECT * FROM WordList
WHERE NewWord='Yes' AND Book IN ('NCE_1','NCE_3','NCE_5')

Answer 4

SELECT * FROM WordList
WHERE NewWord='Yes' 
AND Book IN ('NCE_1','NCE_3','NCE_5')你自己写的那个字符打上单引号就对了SELECT *
FROM WordList
WHERE (NewWord = 'Yes') AND (Book IN ('NCE_1', 'NCE_3', 'NCE_5'))