Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Databases

Orlee Yahalom
PLUS
Orlee Yahalom
Courses Plus Student 2,110 Points
Posted by Orlee Yahalom
Orlee Yahalom
Courses Plus Student 2,110 Points

Can't figure out where the error is.

https://teamtreehouse.com/library/reporting-with-sql/working-with-text/-adding-text-columns-together

I find the video for this task to lack discussion using || with AS...can't figure out where I've gone wrong.

1 Answer

Tabatha Trahan
Tabatha Trahan
21,422 Points
Tabatha Trahan
Tabatha Trahan
21,422 Points

If you are working on the first challenge for the video series that you included a link to, this should work:

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

You want to concatenate the values in the first_name, last_name, and email columns together, along with spaces and the angle brackets. When you concatenate the values, they will return as one column, which you can use AS to alias the column name. I hope this helps, otherwise go ahead and post the code you are using and I can take a look at it.

Arnd-Kisho Langenberg
Arnd-Kisho Langenberg
4,058 Points
Arnd-Kisho Langenberg
Arnd-Kisho Langenberg
4,058 Points

Thank you for sharing! This helped :)

Kind regards, Arnd