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

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

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;