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 nicolabell
nicolabell
18,212 Points

whats wrong with this sql

I can't see whats wrong here, can you? https://teamtreehouse.com/library/sql-basics/getting-data-from-a-database/-categorizing-your-output-with-as

I put:

SELECT name AS "Product Name", description AS "Product Description";

SQL Error: no such column: name

Adam N
Adam N
70,280 Points

provide the url to where you're stuck?

nicolabell
nicolabell
18,212 Points

I've updated the description, thanks!

1 Answer

Adam N
Adam N
70,280 Points

You're not specifying what table youre pulling the columns from. Syntax for doing something like this is:

SELECT CustomerName, City FROM Customers;
nicolabell
nicolabell
18,212 Points

Ah I realised I needed to add 'FROM' - thanks :)

Adam N
Adam N
70,280 Points

np! You can mark this question as solved by choosing a "best answer". :smile: