Databases Querying Relational Databases Set Operations Set Operations

Robbie Thomas
Robbie Thomas
31,092 Points

Set Operations 2 of 6

I put this down

SELECT FruitID, Name FROM Fruit
    WHERE Name < "K"
  UNION
  SELECT VegetableID, Name FROM Vegetable
    WHERE Name < "K"
    ORDER BY Name;

However, it says I do not have the names in order.

1 Answer