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!
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
Christopher Johnson2,066 Points
Why am I receiving "no such column: street" ?
Columns clearly defined in task. One of the columns is street. It returns SQL Errors: no such column: street. Is this again a table name error as I read that occurred a year ago or user error? Please help. Thank you
Query is as follows:
SELECT street|| ","|| city || ","|| state || "," || zip || "."|| country AS addresses;
Sebastian Barbiero6,529 Points
You are missing a FROM statement. Also account for the spaces in the desired format. Your string characters you are directly injecting should have a space. EX. street || ", "|| city
Vittorio Somaschini33,371 Points
please provide your code so that we can have a look.