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
orange sky
Front End Web Development Techdegree Student 4,945 Points<andrew@teamtreehouse.com>
Hello,
The task in my reporting SQL is the below. Can you please help me add <> around the email addresses. I have tried to concatenate but I am still getting a failure.
In the library database there's a patrons table listing all the users of the library. The columns are id, first_name, last_name, address, email, library_id and zip_code. Generate a list of strings that are in the following format: Andrew Chalkley andrew@teamtreehouse.com. Concatenate the first name, last name and email address for all users. Alias it to to_field. This will be used in the "To" field in email marketing.
2 Answers
Alexander Nikiforov
Java Web Development Techdegree Graduate 22,175 PointsHi, orange sky
The question is indeed a bit tricky. There is some problem with HTML braces/ SQL braces.
Please read discussion in this question for more :
orange sky
Front End Web Development Techdegree Student 4,945 PointsThanks Alexander, I will check your link later to try this problem again.
Steven Parker
231,140 PointsSteven Parker
231,140 PointsPlease show your SQL code.
Then someone can help you fix it.