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
Knut Ringheim Lunde
38,811 PointsConcatenating text: challenge 2
I've have been staring at the query for too long now.
SELECT street || ", " || city || ", " || state || " " || zip || ". " || country AS address FROM addresses;
The data result seems to be correct. The only error message I get is "You should try writing a select", which is not helpful.
Does anyone see the problem?
Knut Ringheim Lunde
38,811 PointsIt is the objective two on this code challenge https://teamtreehouse.com/library/reporting-with-sql/working-with-text/concatenating-text .
1 Answer
Steven Parker
231,236 PointsWhen I paste your query from above directly into the challenge, it passes!
Try again?
Knut Ringheim Lunde
38,811 PointsOh, it works now! Weird.. Anyway; thank you so much! I was sure I had miss a comma or something, but I just couldn't find it!
Steven Parker
231,236 PointsSteven Parker
231,236 PointsAt first glance, this looks good. Please provide a link to the course page to allow for viewing the requirements and confirming a solution.
(And yes, that message is not much help.)