Databases Reporting with SQL Working with Text Concatenating Text

Jenn Giulietti
Jenn Giulietti
4,888 Points

concatenate SQL

I am stuck on how to include the part where the email address has brackets. Do I have to include two alias directions on the same line??

******This is the challenge. 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.

Type in your command below, then press Ctrl-Enter. ****MY error code Bummer: You're missing the angle brackets around the email address.

****My current answer

SELECT first_name ||" "|| last_name||" "|| email AS to_field FROM patrons;

Joshua Connor
Joshua Connor
7,214 Points

Your error has a big clue, typically when you type an email address it might look something like:

<me@email.com>

you need to add those '<' and '>' around your email. hope this helps.

2 Answers

Jenn Giulietti
Jenn Giulietti
4,888 Points

Thanks Joshua. I tried this and it is also not working. How do I alias two things in the same statement?

SELECT first_name|| " " ||last_name||" "||email AS "<email>", AS "to_field" FROM patrons;

Van Nguyen
Van Nguyen
2,367 Points

Does anyone join in and help Jenn on this ? I stuck on this one too.