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

Posted by Jorge Borge
Jorge Borge
12,886 Points

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
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

Jorge Borge
Jorge Borge
12,886 Points
Jorge Borge
Jorge Borge
12,886 Points

I have tried everything ...still nothing

Christopher Hall
Christopher Hall
9,052 Points
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.

Mosses Akizian
Mosses Akizian
8,136 Points
Mosses Akizian
Mosses Akizian
8,136 Points

You need to add table name followed by column name.

SELECT actors.name FROM actors;