Welcome to the Treehouse Community

The Treehouse Community is a meeting place for developers, designers, and programmers of all backgrounds and skill levels to get support. Collaborate here on code errors or bugs that you need feedback on, or asking for an extra set of eyes on your latest project. Join thousands of Treehouse students and alumni in the community today. (Note: Only Treehouse students can comment or ask questions, but non-students are welcome to browse our conversations.)

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and a supportive community. Start your free trial today.

Databases

Christopher Johnson
Christopher Johnson
2,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;

2 Answers

Sebastian Barbiero
Sebastian Barbiero
6,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 Somaschini
Vittorio Somaschini
33,371 Points

Hi Christopher.

please provide your code so that we can have a look.

Vito

Christopher Johnson
Christopher Johnson
2,066 Points

SELECT street || "," || city || "," || state || "," || zip || "."|| country AS address; SQL Error: no such column: street

In an ecommerce database there's a addresses table. There is an id, nickname, street, city, state, zip, country and user_id columns.

Concatenate the street, city, state, zip and country in the following format. Street, City, State Zip. Country e.g. 34 NE 12 st, Portland, OR 97129. USA

Alias the concatenated string as address