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.

Louise St. Germain
Louise St. Germain
19,373 Points

Hello Hugo,

Was there something specific you need help with or that you don't understand? (This is just the challenge question repeated.)

1 Answer

Steven Parker
Steven Parker
176,364 Points

Since you didn't ask a question, I'm guessing you'd like some generic hints:

  • use the concatenation operator ("|") to combine strings together
  • remember to include spaces between words using string literals
  • also include the angles ("<" and ">") on either side of the "email" field
  • don't forget the alias name ("to_field")