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

PHP

Posted by Kamil Mrozek
Kamil Mrozek
2,319 Points

Problem with basic SQL statement. Database Foundation.

Hey! I have a problem.

Write a SELECT statement that retrieves all "movies" with the "year" first and the "title" second.

Here is my statement: SELECT movie.year . movie.title FROM movies; and i have get this: Bummer! You're missing a comma in your query. I tried the all of combination and nothing happens.

2 Answers

Aiden Yi
Aiden Yi
9,292 Points
Aiden Yi
Aiden Yi
9,292 Points

I think you are missing comma (,) between movie.year and movie.title. And instead of movie.year, you should try movies.year.

Try this statement below!

SELECT movies.year, movies.title FROM movies;

Khaleel Hamid
Khaleel Hamid
5,258 Points
Khaleel Hamid
Khaleel Hamid
5,258 Points

"Bummer! You're missing a comma in your query". It says your missing the comma right in your error message, you have a period (.) instead in the current code.

Have you tired putting in the comma between the year and title of movie?