SQL Language

[Sol]

Can anyone help me to figure out how to perform a multiple task activity?
Here is the deal:

"List the book code and title of every book that has the type SFI, HOR, or
ART."

The following is how far I got:

SELECT Bookcode, Title, Price, Type
FROM Book
WHERE Type='SFI'
And Type='HOR'
And Type='ART';

However, when I clicked the Run button a blank query came up.
Thank you,
Salomon

 

[fredg]

Can anyone help me to figure out how to perform a multiple task activity?
Here is the deal:

"List the book code and title of every book that has the type SFI, HOR, or
ART."

The following is how far I got:

SELECT Bookcode, Title, Price, Type
FROM Book
WHERE Type='SFI'
And Type='HOR'
And Type='ART';

However, when I clicked the Run button a blank query came up.
Thank you,
Salomon

Sounds like a classroom assignment, as did the question you posted 10
minutes earlier with the same subject line. Do we get credit for your
grade?

I'll point you in the correct direction and let you figure it out.
Is there a book in your table whose type is "SFI" and "HOR" and "ART"?
Or will the Type be either "SFI" or "HOR" or "ART"?

By the way, TYPE is an Access field property, should not be used as a
field name.
For an even more complete list of reserved words, see:
http://www.allenbrowne.com/AppIssueBadWord.html