David Corrales4,655 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";
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";