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
Breon Bowser
788 PointsHaving problems using Angle Brackets in Challenge Task with Concatenation Operator..Please Help?
Please Help?
2 Answers
Steven Parker
231,008 Points
You forgot to show your code (and link to the challenge).
But based on questions other students have asked, I can give you some general hints:
- Remember to enclose literal strings in quotes
- Remember to include a space in front of the open angle (
" <") - Remember to place the concatenation operator (
||) between the strings being joined (literals or field names) - If an alias is required, be sure to place it after all the combined strings
If one or more of these hints doesn't solve your issue, please show your code and provide a link to the challenge.
Breon Bowser
788 PointsHere is the code
SELECT first_name || " " || last_name || " " || email FROM patrons AS "to_field";
Link to the Challenge
https://teamtreehouse.com/library/reporting-with-sql/working-with-text/concatenating-text
Steven Parker
231,008 PointsYou're missing the angle brackets on both sides of email, and the alias must come after the combined strings (as I hinted above) and before the FROM.
Breon Bowser
788 PointsBreon Bowser
788 PointsTrying to add angle brackets around email address in challenge task involving concatenation operator