Databases Querying Relational Databases Set Operations Set Operations

Peris Kwamboka
Peris Kwamboka
1,382 Points

Need help on returning fruits and vegetables with letters A to K - Task 2 challenge

When am running this, i am getting a message that UNION query has not returned letters A to K. Below is my code

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

2 Answers

KRIS NIKOLAISEN
PRO
KRIS NIKOLAISEN
Pro Student 51,733 Points

You will want to use

 Name < "L"

to include fruits and vegetables that begin with K