Databases Reporting with SQL Working with Text Concatenating Text

Posted by Duane McAllister
Duane McAllister
2,858 Points

Am I doing something wrong with how I'm coding

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

1 Answer

KRIS NIKOLAISEN
KRIS NIKOLAISEN
53,478 Points
KRIS NIKOLAISEN
KRIS NIKOLAISEN
53,478 Points

The error message states: You're missing the angle brackets around the email address.

You need to concatenate those as well.