Databases Querying Relational Databases Set Operations Set Operations

Gurdeep singh
Gurdeep singh
1,522 Points

Need to know What's wrong with this code

I have banged by head and can't get a way through Need to know what is wrong with this code

Gurdeep singh
Gurdeep singh
1,522 Points

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.

AND CODE I USED IS > SELECT Name FROM Fruit WHERE Name < "K" UNION SELECT Name FROM Vegetable WHERE Name < "k" ORDER BY Name DESC;

2 Answers

KRIS NIKOLAISEN
KRIS NIKOLAISEN
54,196 Points

You'll want to do < "L" so that K is included

SELECT Name FROM Fruit WHERE Name < "L" UNION SELECT Name FROM Vegetable WHERE Name < "L";
Gurdeep singh
Gurdeep singh
1,522 Points

Thank you!!! Will.it work if I used it as name <= "k"?

KRIS NIKOLAISEN
KRIS NIKOLAISEN
54,196 Points

No. That would apply to fruits or vegetables named "k"

Gurdeep singh
Gurdeep singh
1,522 Points

Ahh got it I am assigning it how stupid I am. Thank you for help much love!!