Databases Reporting with SQL Working with Text Concatenating Text

Jerry Lombardo
Jerry Lombardo
945 Points

Concatenation

From a partners table, I'm tying to concatenate first_name, last_name and email (with spaces in between) and Alias it as "to_field". I tried SELECT first_name || " " || last_name || " " || email AS to_field FROM partners; and it said to put angle brackets around email. So I tried SELECT first_name || " " || last_name || " " || <email> AS to_field FROM partners; and then got the generic 'something is wrong with your code.
What am I doing wrong?

2 Answers

KRIS NIKOLAISEN
KRIS NIKOLAISEN
53,537 Points

Some hints:

  • Try concatenating the brackets around email
  • The table name is patrons
Jerry Lombardo
Jerry Lombardo
945 Points

Thanks Kris that worked!