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

Victor Rivera
Victor Rivera
827 Points
Posted by Victor Rivera
Victor Rivera
827 Points

Bring back both the first name and last name for every person in the phone book. The phone will filter the appropriate s

SELECT first_name, last_name, FROM phone_book;

SQL Error: near "FROM": syntax error

Ari Misha
Ari Misha
19,323 Points
Ari Misha
Ari Misha
19,323 Points

Hiya Victor! can you link us to the challenge?

2 Answers

Tadeáš Firich
Tadeáš Firich
7,866 Points
Tadeáš Firich
Tadeáš Firich
7,866 Points

Hello Victor. I think your problem is in the extra comma before FROM. Let me explain it. This is you code:

SELECT first_name, last_name, FROM phone_book;

And i think this is the right code:

SELECT first_name, last_name FROM phone_book;

Was it helpful for you? You can give me some points :).

Victor Rivera
Victor Rivera
827 Points
Victor Rivera
Victor Rivera
827 Points

Hello Tadeas, thanks for your reply, I do not what happened, I think I was doing exactly that as you pointed out but it would not work. This morning I tried and it did work, what was going on I do not know. Thank you again for your help. b/r Victor