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

Christine otieno
Christine otieno
3,901 Points
Posted by Christine otieno
Christine otieno
3,901 Points

> SELECT street, city, state, zip, FROM customer_addresses; SQL Error: near "FROM": syntax error why is it wrong?

SELECT street, city, state, zip, FROM customer_addresses;

SQL Error: near "FROM": syntax error

why did I get a error

1 Answer

Levy Bettley
Levy Bettley
11,517 Points
Levy Bettley
Levy Bettley
11,517 Points

Hi Christine,

I believe the issue is the comma that is after "zip" before "FROM". You do not need a comma between the SELECT variables and the FROM keyword. Please try:

SELECT street, city, state, zip FROM customer_addresses

Hope this helps!