Databases Querying Relational Databases Set Operations Set Operations

Brian Poirier
Brian Poirier
7,678 Points

select fruit and vegetables. what's wrong with this? SELECT * FROM fruit UNION SELECT * FROM vegetable

SELECT * FROM fruit UNION SELECT * FROM vegetable

1 Answer

Steven Parker
Steven Parker
177,843 Points

The challenge asks you to "Create a distinct result set of fruit and vegetable names."

You've got the distinct combination, but instead of all columns (*) the challenge only wants the Name fields.