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 Rohit Gopalan
Rohit Gopalan
81,945 Points

Why is this code incorrect for the code challenge of concatenating strings in SQL?

When I write the correct code for this challenge, I am not sure why it is considered incorrect. Any help would be much appreciated.

select street||', '||city||', '||state||' '||zip||'. '||country as address from customers

SQL Error: no such column: street

1 Answer

Steven Parker
Steven Parker
231,261 Points
Steven Parker
Steven Parker
231,261 Points

I had the same issue myself. It turns out they had a few bugs on initial rollout, and this one was caused by the wrong table name. It has been fixed now.

:point_right: Give it another try (using the new table name).

Christopher Johnson
Christopher Johnson
2,066 Points
Christopher Johnson
Christopher Johnson
2,066 Points

I'm having this issue now. It's reporting same error no such column street. Any ideas?