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

Databases

Posted by Gabriel E
Gabriel E
8,916 Points

Challenge error, "Did you select from the results table?" -- Please Help!

Hello and good afternoon all! I'm working through this challenge, which I believe is linked to this post, and I'm having a bit of trouble. The only error I'm receiving is the error, "Did you select from the results table?" But yes, I did indeed. The start of my statement was "SELECT * FROM results". I'm not sure what else I need, then. Any advice and help would be appreciated! Thank you!

~ Gabriel

Steven Parker
Steven Parker
231,261 Points
Steven Parker
Steven Parker
231,261 Points

Could you post the whole query, and a link to the challenge (or at least the name of the course, and the name of the challenge)?

Gabriel E
Gabriel E
8,916 Points

Sure, sorry to get back so late! Gone on holiday. And yes I will do that ASAP.

Gabriel E
Gabriel E
8,916 Points

Ah! Got it! I just needed to rearrange a few statement ops in order to get the "played on or after" to work! Thanks for your help everyone!!

~ Gabriel

1 Answer

Paul Ryan
Paul Ryan
4,584 Points
Paul Ryan
Paul Ryan
4,584 Points

Hi Gabriel. I am not sure of how much help I can be. I checked the course and a simple select * from results worked for me. Not sure why it isn't working for you. Are you sure you didn't make a tiny typo?