
Jenn Giulietti
4,888 PointsCONCAT SQL
Please help, I am stuck on how to alias both the email and the to_field. Thank you for your time
****The challenge*
Challenge Task 1 of 2 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
*The very unhelpful hint Bummer: There's something wrong with your SQL statement. Please review your code and try again.
*My code*
SELECT first_name || " " || last_name|| " " || email AS "<email>", AS to_field FROM patrons;
Megan Amendola
Treehouse TeacherMegan Amendola
Treehouse TeacherHi! This poster had a similar issue: https://teamtreehouse.com/community/i-really-did-not-want-to-ask-for-help-on-this-one-as-i-think-i-understand-the-concepthere-is-the-code-i-tried