Challenge : Bobby's Hobbies step three problem
I did this on step three
SELECT * FROM hobbies WHERE person_id = 1;
How is this correct
I did this on step three
SELECT * FROM hobbies WHERE person_id = 1;
How is this correct
The instructions for Step 3 of Bobby's Hobbies are:
Now, add an additional query that shows only the name and hobbies of 'Bobby McBobbyFace', using JOIN combined with WHERE.
SELECT * FROM hobbies WHERE person_id = 1;
is a query that shows all of the fields (not only the name and hobbies) of ID 1 (Not 'Bobby McBobbyFace',- to the auto-grader, this makes a difference). Also, there is no JOIN clause in this query.
Vui lòng đăng nhập để lại bình luận.