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

Posted by ak37
ak37
2,344 Points

Categorizing your Output with AS

I keep getting a SQL Error stating the error is near "Name" syntax, but I am not sure what exactly is wrong?

Steven Parker
Steven Parker
231,269 Points
Steven Parker
Steven Parker
231,269 Points

Please show your complete query so we can take a look. A link to the course page would also be helpful.

1 Answer

Zac Mazza
Zac Mazza
5,867 Points
Zac Mazza
Zac Mazza
5,867 Points

A few considerations - with the AS syntax, if it's a single word, you can just include it. If it's multiple words, you need to put the string in quotations.

SELECT pr AS PRICE
SELECT pr AS "PRICE OF CAR"

That may be causing the syntax error.

Thanks, Zac