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.

General Discussion

I dont understand this question

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.

4 Answers

Christopher Mell
Christopher Mell
9,152 Points

SELECT table_name, column_name, data_type

Or something like that I believe is what you are looking for

I have tried everything ...still nothing

Christopher Hall
Christopher Hall
9,052 Points

Ah, what they're talking about here is like the example below:

SELECT actors.column_name FROM actors

The reason you might want to write out the full table and column name is to avoid conflicts when you're doing more advanced statements such as a JOIN. If table #1 has a id column and you're joining it to table #2 which also has an id column, you need to specify which one you want or you will get an error.

You need to add table name followed by column name.

SELECT actors.name FROM actors;