I got asked to concatenate the first name last name and emails from the patrons table, the system keeps telling me that the query didn't bring the emails back in the right format. Does anyone know what I'm doing wrong?
KRIS NIKOLAISEN53,362 Points
The angle brackets need to be concatenated as well. "<email>" will be retrieved literally as "<email>"
SELECT first_name || " " || last_name || " <" || email || ">" AS to_field FROM patrons