Databases Reporting with SQL Working with Text Concatenating Text

In the library database there's a patrons table listing all the users of the library. The columns are id, first_name, la

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.

Can you post your SQL or are you stuck on where to begin?

2 Answers

Steven Parker
Steven Parker
203,207 Points

Here's a few hints based on questions asked by other students about this challenge:

  • when you concatenate the fields, remember to add spaces between them
  • also be sure to add the angles "<" and ">" around the email
  • note that the alias should be "to_field" (and not "To")

If you still have trouble, post your query code and/or ask specific questions about your issue(s).

what is wrong with my code?

select first_name || " " || last_name || " <" || email || ">" || AS 'to_field' from patrons;

@chosungrowth You don't need to concatenate the alias. You also probably would have received a quicker response by starting a new topic.