Welcome to the Treehouse Community
The Treehouse Community is a meeting place for developers, designers, and programmers of all backgrounds and skill levels to get support. Collaborate here on code errors or bugs that you need feedback on, or asking for an extra set of eyes on your latest project. Join thousands of Treehouse students and alumni in the community today. (Note: Only Treehouse students can comment or ask questions, but non-students are welcome to browse our conversations.)
Looking to learn something new?
Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and a supportive community. Start your free trial today.
What column am I missing from my query?
The question mentions there are only four columns in products: id, name, description and price. I included all four columns in my query and yet it returns with an error saying "You didn't select all columns". Can someone help point out which one I am missing?
Steven Parker218,707 Points
When they ask for "all columns", it implies that you should use the "
SELECT * " syntax which selects all columns without naming any explicitly.
Thanks guys, I realised instantly after I posted the question which was weird because the questions prior, I typed all the columns and that seemed to work.
Nethertheless a good lesson learned for the future.