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
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.
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 Hall9,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;