dfeem
3,818 PointsStuck 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 Student 44,108 PointsSELECT first_name || " " || last_name || " <" || email || ">" AS 'to_field'
FROM patrons
KRIS NIKOLAISEN
Pro Student 44,108 Pointsyou are missing the angle brackets that enclose the email address
dfeem
3,818 PointsI'm still confused. I tried to put angle bracket at various places in statement and haven't been able to find correct solution?
dfeem
3,818 Pointsdfeem
3,818 PointsThanks Kris! I tried it like that, but I didn't leave a space before the first bracket. I appreciate it.