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 Querying Relational Databases Set Operations Set Operations

Daniele Santos
Daniele Santos
16,536 Points
Posted by Daniele Santos
Daniele Santos
16,536 Points

Querying issues SELECT Name FROM Fruit UNION SELECT Name FROM Vegetable WHERE Name BETWEEN "A" AND "K";

I Cant get this to work

Steven Parker
Steven Parker
231,184 Points
Steven Parker
Steven Parker
231,184 Points

Show the query string you're trying, and perhaps someone can give you pointers to fix it.

1 Answer

Steven Parker
Steven Parker
231,184 Points
Steven Parker
Steven Parker
231,184 Points

Since you haven't posted your code, here's a couple of generic hints:

  • while the word "between" describes the task, it might not correspond well with the SQL keyword
  • on strings, inequality comparisons check alphabetical order