Databases Reporting with SQL Working with Text Concatenating Text

Stuck on this task?

SELECT first_name || " " || last_name || " " || email AS "to_field" FROM patrons;

That's what I wrote and it's not correct.

2 Answers

KRIS NIKOLAISEN
PRO
KRIS NIKOLAISEN
Pro Student 45,972 Points
SELECT first_name || " " || last_name || " <" || email || ">" AS 'to_field'
FROM patrons

Thanks Kris! I tried it like that, but I didn't leave a space before the first bracket. I appreciate it.

KRIS NIKOLAISEN
PRO
KRIS NIKOLAISEN
Pro Student 45,972 Points

you are missing the angle brackets that enclose the email address

I'm still confused. I tried to put angle bracket at various places in statement and haven't been able to find correct solution?