Databases Querying Relational Databases Set Operations Set Operations

David Corrales
David Corrales
4,646 Points

Something is missing to organize this, can someone help? I appreciate you!!

There are two tables Fruit and Vegetable table. The Fruit table has a FruitID and a Name column and the Vegetable table has a VegetableID and Name column.

Create a list of all fruits and vegetables starting with the letters A through K . In other words all fruit and vegetables that don't start with the letter L to Z.

Type in your command below, then press Ctrl-Enter.

Bummer: Your UNION queries didn't bring back a union of fruits and veggies beginning with the letters A through K!

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

1 Answer

KRIS NIKOLAISEN
KRIS NIKOLAISEN
54,187 Points

Your first select statement needs a where clause as well:

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

Can you help me? I tried using

SELECT Name FROM Fruit WHERE Name BETWEEN "A" AND "L" UNION SELECT Name FROM Vegetable WHERE Name BETWEEN "A" AND "L";

this error appear: Bummer: Your UNION queries didn't bring back a union of fruits and veggies beginning with the letters A through K!

is BETWEEN not applicable in this problem?

Thank you.