Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Simple Problem

Status
Not open for further replies.
SMAlvarez

SMAlvarez

Programmer
Dec 4, 2005
27
0
0
US
what is wrong with the following code?

WHERE Ratings.Rating = (Coffee.Rating AND Country in('Dominican Republic', 'Jamaica', 'Colombia', 'Venezuela', 'Mexico');

country is in a table called Coffee if that helps. Thanks for any help!
 
Sort by date Sort by votes
Parentheses are no good. Try this:

Code: 
WHERE Ratings.Rating = Coffee.Rating AND Country in('Dominican Republic', 'Jamaica', 'Colombia', 'Venezuela', 'Mexico');

Hope it helps,

Alex

Ignorance of certain subjects is a great part of wisdom
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

shifter480
  • Locked
  • Question
SQL query logic problem
Replies
7
Views
31
shifter480
shifter480
kdbenson
  • Locked
  • Question
Solving a SQL problem without using an OLAP function
Replies
3
Views
31
JarlH
JarlH
MyTool
  • Locked
  • Question
Trouble with a simple SQL statement
Replies
1
Views
26
r937
r937
mark1110
  • Locked
  • Question
Group By Optimize Problem
Replies
8
Views
29
JarlH
JarlH
alohaaaron
  • Locked
  • Question
SQL Join + Subquery Problem
Replies
4
Views
38
alohaaaron
alohaaaron

Part and Inventory Search

Sponsor

Back
Top