Databases Reporting with SQL Working with Text Concatenating Text

Lyola Rowe
Lyola Rowe
3,803 Points

I'm typing this and getting "incorrect format" error. What am I doing wrong?

select first_name || " " || last_name || " " || "<" || email || ">" as “To” from patrons;

1 Answer

Jennifer Nordell
Jennifer Nordell
Treehouse Teacher

Hi there, Lyola Rowe! It's expecting a different alias for the results. You've set up an alias named "To", but it wants an alias of to_field. Also, you will need to remove the quotation marks from around the alias name. It's expecting AS to_field FROM patrons. The rest looks spot on!

Hope this helps! :sparkles: