Databases Querying Relational Databases Set Operations Set Operations

Jeremy Guida
Jeremy Guida
8,022 Points

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
200,698 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).

Jeremy Guida
Jeremy Guida
8,022 Points

THANK YOU! I should read more carefully!