Jeremy Guida8,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;
Steven Parker200,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).