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

Eric Thomas
seal-mask
.a{fill-rule:evenodd;}techdegree
Eric Thomas
Front End Web Development Techdegree Student 3,689 Points
Posted by Eric Thomas
.a{fill-rule:evenodd;}techdegree
Eric Thomas
Front End Web Development Techdegree Student 3,689 Points

I need help with concatenate and combining columns.

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

SQL Error: near "AS": syntax error

1 Answer

Steven Parker
Steven Parker
231,128 Points
Steven Parker
Steven Parker
231,128 Points

I'm not sure we're seeing your query correctly.

Unless you format your code using the Markdown Cheatsheet instructions, it could be that some symbols you used are not showing correctly. But here's some hints based on what it looks like:

  • don't use a concatenation operator ("||") directly before the alias ("AS")
  • don't place two concatenation operators together with nothing in between
  • make sure any literal strings are complete enclosed (at both ends) with quote marks

To enable the most complete analysis, always format your code and include a link to the course page you're working with.