Concatenate objective for Reporting with SQL

That is probably the link to challenge

https://teamtreehouse.com/library/reporting-with-sql/working-with-text/concatenating-text

The problem with your solution is quite simple.

The e-mail you have to write is

Andrew Chalkley <andrew@teamtreehouse.com>

The e-mail you obtain with your SQL query, that is

SELECT first_name || " " || last_name AS "FULL NAME", email AS "to_field" FROM patrons;

Is the following e-mail

Andrew Chalkley andrew@teamtreehouse.com

So you see the difference ? You forgot to add brackets "<", ">" on both sides.

Thanks for the responses, and here is my link:

https://teamtreehouse.com/library/reporting-with-sql/working-with-text/concatenating-text

But yes, I think you are right Jason, I clicked right on the challenge so I was hoping that would link directly to it, but I guess it didn't, thanks for bringing this up, as this seemed to happen to me last week as well.

When I try to string the email like this it gives me the error below.

>SELECT first_name || " " || last_name AS "FULL NAME" || " " || email AS "to_field" FROM patrons;

>SQL Error: near "||": syntax error

If I write >SELECT first_name || " " || last_name AS "FULL NAME" || " " || <email> AS "to_field" FROM patrons;

As suggested, by Alexander, I still get the same error - I didn't know I was supposed to use brackets in the query around email???