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.

Databases SQL Basics Finding the Data You Want Filtering by Comparing Values

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?

Tim Oltman
Tim Oltman
7,718 Points

Hi Joe,

Try selecting all of the columns with * instead of listing them all in your query.

Tim

2 Answers

Steven Parker
Steven Parker
218,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.