Databases Querying Relational Databases Set Operations Set Operations

Daniele Santos
Daniele Santos
16,536 Points

Querying issues SELECT Name FROM Fruit UNION SELECT Name FROM Vegetable WHERE Name BETWEEN "A" AND "K";

I Cant get this to work

Steven Parker
Steven Parker
203,270 Points

Show the query string you're trying, and perhaps someone can give you pointers to fix it.

1 Answer

Steven Parker
Steven Parker
203,270 Points

Since you haven't posted your code, here's a couple of generic hints:

  • while the word "between" describes the task, it might not correspond well with the SQL keyword
  • on strings, inequality comparisons check alphabetical order