dfeem
4,595 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 48,713 PointsSELECT first_name || " " || last_name || " <" || email || ">" AS 'to_field'
FROM patrons
KRIS NIKOLAISEN
Pro Student 48,713 Pointsyou are missing the angle brackets that enclose the email address
dfeem
4,595 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
4,595 Pointsdfeem
4,595 PointsThanks Kris! I tried it like that, but I didn't leave a space before the first bracket. I appreciate it.