Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Databases SQL Basics Finding the Data You Want Finding the Data You Want Review

Miguel Nunez
Miguel Nunez
3,266 Points
Posted by Miguel Nunez
Miguel Nunez
3,266 Points

If I wanted to return rows that match both conditions, which keyword would I use?

SELECT <columns> FROM <table> WHERE <condition 1> <condition 2>;

4 Answers

Charlie Harcourt
Charlie Harcourt
8,046 Points
Charlie Harcourt
Charlie Harcourt
8,046 Points

The correct answer is "OR"

:)

Steven Parker
Steven Parker
231,271 Points
Steven Parker
Steven Parker
231,271 Points

:point_right: Put "AND" (without the quotes) between the two conditions.

Then you will see "Well done! That's the correct answer."

This was discussed in Filtering on More than One Condition.

Miguel Nunez
Miguel Nunez
3,266 Points
Miguel Nunez
Miguel Nunez
3,266 Points

I did but it said its wrong still I put it with quotes and with out quotes i'm lost now again.

Terri Valentine
Terri Valentine
23,034 Points
Terri Valentine
Terri Valentine
23,034 Points

The correct answer is or without any quotation marks.