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

Databases

Posted by Dan Watson
Dan Watson
1,921 Points

ambiguous column name?

What is the ambiguous column name here? I have specified which table to pull the column information from

1 Answer

Christof Baumgartner
Christof Baumgartner
20,864 Points
Christof Baumgartner
Christof Baumgartner
20,864 Points

It says that you use two tables, that have the same name for one column, but u did not specify from which table you wanted to have it. This can be in your select clause, but also in your where and group by. Try to specify before each column name the table name with a dot, like 

SELECT table1.column1 
from table1 
...