Welcome to the Treehouse Community
Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.
Looking to learn something new?
Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.
Start your free trial
Lucas Chatham
1,852 PointsKeep running into "You didn't select all the columns." Suggestions?
Challenge: We're back on the smartphone, but our phone_book is a mess. There's a phone_book table but there's missing information in a couple of the columns.The phone_book has the following columns id, first_name, last_name and phone.Find all contacts in the phone_book where the phone number is missing so we can go and ask them for their number.
My Code: select id, first_name, last_name, phone from phone_book where phone is null
All 4 columns are present in my code, yet I keep getting wrong answer stating that I didn't put all columns. Thoughts? And thanks.
2 Answers
Rod MIky
18,784 PointsI think you have the right idea. Always remember that you need to specify what table you are targeting or working with. You want your sql query to look something like the query below. SELECT column_names FROM table_name WHERE column_name IS NULL;
Hayley Risley
9,510 PointsIf you are still having issues here is the code that worked for me: SELECT * FROM phone_book WHERE phone IS NULL;