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 Reporting with SQL Working with Text Concatenating Text

Posted by Jennifer Sanders
Jennifer Sanders
1,747 Points

Help with code, please.

SELECT * FROM PATRONS WHERE ("FIRST_NAME" || "LAST_NAME" || "EMAIL"AS "<EMAIL>") AS "TO_FIELD";
Rich Donnellan
Rich Donnellan
Treehouse Moderator 27,708 Points
Rich Donnellan
Rich Donnellan
Treehouse Moderator 27,708 Points

Question updated with code formatting. Check out the Markdown Cheatsheet below the Add an Answer submission for syntax examples, or choose Edit Question from the three dots next to Add Comment to see how I improved the readability.

1 Answer

Travis Alstrand
seal-mask
.a{fill-rule:evenodd;}techdegree seal-36
Travis Alstrand
Treehouse Project Reviewer
Travis Alstrand
.a{fill-rule:evenodd;}techdegree seal-36
Travis Alstrand
Treehouse Project Reviewer

You're on the right track here, there are some capitalization issues though and the placement of your <>s. We don't need to alias the email, just concatenate hard angle brackets around it like so.

I hope this helps and makes sense. 

SELECT first_name || " " || last_name || " <" || email || ">" 
AS "to_field" 
FROM patrons;
Jennifer Sanders
Jennifer Sanders
1,747 Points

Travis,

Thank you so much! I have been stuck on this question for what feels like forever!

Jenny