Welcome to the Treehouse Community
Looking to learn something new?
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.
Christopher Mell9,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 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;