Databases Reporting with SQL Working with Text Concatenating Text

Justin Young
Justin Young
7,015 Points

SELECT first_name || " " || last_name || " " || <email> AS "to_field" FROM patrons; [SOLVED]

I feel like the syntax is correct but it keeps telling me something is wrong with my code. I've also refreshed the browser and tried again.

Any thoughts would be welcome :-)

Justin Young
Justin Young
7,015 Points

I figured it out. SMH. I found a thread I missed that showed I needed the quotes around the brackets and piped to concatenate them to the word email. SELECT first_name || " " || last_name || " " || "<" || email || ">" AS "to_field" FROM patrons;

Thanks anyways