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

Development Tools

Posted by Rana Melissa Baghdar
Rana Melissa Baghdar
9,425 Points

Challenge task 3

every single code i type in, is wrong. The task itself: From the actors table select the name column using the long form version of the column name i.e. table name followed by the column name.

Any ideas how i can make it work?

2 Answers

Iain Simmons
Iain Simmons
Treehouse Moderator 32,305 Points

You haven't linked the challenge this is related to, but I'm going to guess it should be something like:

SELECT actors.name FROM actors

You use the table.column syntax.

Rana Melissa Baghdar
Rana Melissa Baghdar
9,425 Points

Oh, yea kinda forgot that! Figured out the issue thou, I was writing "movies" instead of "actors". Anyways, thanks! :)

Iain Simmons
Iain Simmons
Treehouse Moderator 32,305 Points

Hi Rana Baghdar, if my answer helped, please mark it as best answer so that people know that your question has been resolved.

Ary de Oliveira
Ary de Oliveira
28,298 Points
Ary de Oliveira
Ary de Oliveira
28,298 Points

SQL DATABASE Foundations

Challenge Task 1 of 3 Write a SELECT statement that retrieves all "movies" with the "year" first and the "title" second. Type in your command below, then press Enter.

SELECT year, title FROM movies;

Challenge Task 2 of 3 Write a SELECT statement that retrieves only the "title" from the "movies" table. Type in your command below, then press Enter.

SELECT title FROM movies;

Challenge Task 3 of 3 From the actors table select the name column using the long form version of the column name i.e. table name followed by the column name. Type in your command below, then press Enter.

SELECT actors.name FROM actors