Welcome to the Treehouse Community

The Treehouse Community is a meeting place for developers, designers, and programmers of all backgrounds and skill levels to get support. Collaborate here on code errors or bugs that you need feedback on, or asking for an extra set of eyes on your latest project. Join thousands of Treehouse students and alumni in the community today. (Note: Only Treehouse students can comment or ask questions, but non-students are welcome to browse our conversations.)

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and a supportive community. Start your free trial today.

Databases Querying Relational Databases Set Operations Set Operations

Katie Martens
Katie Martens
1,587 Points

Need the WHERE clause?

I thought I needed a WHERE clause in both queries, and I know I need the UNION set operation, but wasn't sure how I'm messing up. My code is copied and pasted below:

SELECT Name FROM Fruit WHERE Name >= 'A' and Name < 'K' UNION SELECT Name FROM Vegetable WHERE Name >= 'A' and Name < 'K';

1 Answer

Steven Parker
Steven Parker
216,891 Points

The instructions say to include names that begin with "K", so you need to set your upper limit to the next letter ("L"). Also, you don't need to exclude names starting with letters before "A" (since there aren't any).

SELECT Name FROM Fruit WHERE Name < 'L' UNION SELECT Name FROM Vegetable WHERE Name < 'L';