Databases Querying Relational Databases Set Operations Set Operations

Task 1 of 6: SQL Set Operations

Pretty simple problem - return a union of two tables (vegetable and fruit) with unique values. Each table has two columns, fruitid, name and vegetableid, name. What am I doing wrong here?

I've tried using *, and I've tried specifying the table before each column (Vegetable.VegetableID, etc.). I receive the error: SQL queries did not return a UNION.

Select VegetableID, Name FROM Vegetable UNION Select FruitID, Name FROM Fruit;

1 Answer

Steven Parker
Steven Parker
203,206 Points

The instructions for task 1 say "Create a distinct result set of fruit and vegetable names."

So just select "Name" from both tables (no ID's).

THANK YOU! I should read more carefully!