Welcome to the Treehouse Community
Looking to learn something new?
SQL Error: ambiguous column name: title
multiple conditions challenge 2
Steven Parker220,450 Points
Since you didn't show your code or reference the challenge I'm taking a guess here. But I think it's likely that you might see that error when you
JOIN two tables that both have a column named
title. So if you want to show that column, or use it in a filter clause, you need to fully specify it by putting the name of the table it comes from before the column name, and separate them with a period. For example, if it came from a table named "books" then instead of just "
title" you would write "
Let me know if I guessed the issue, and if not, please show the actual code and provide a link to the course.