Welcome to the Treehouse Community
The Treehouse Community is a meeting place for developers, designers, and programmers of all backgrounds and skill levels to get support. Collaborate here on code errors or bugs that you need feedback on, or asking for an extra set of eyes on your latest project. Join thousands of Treehouse students and alumni in the community today. (Note: Only Treehouse students can comment or ask questions, but non-students are welcome to browse our conversations.)
Looking to learn something new?
Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and a supportive community. Start your free trial today.
Ronnie Sokha939 Points
"Insert a Review" exercise on SQL Playground - Practice: Adding Data Practice Session
I am trying to add a review for the E.T. the Extra-Terrestrial movie but how do you do so if you do not know the movie_id? Do I enter the SELECT statement inside an INSERT statement to find the ID then INSERT my review for that particular movie_id?
Steven Parker218,596 Points
You could either look at the reviews table and see what the assigned ID is, or you could have the DB do it for you by using a subquery in the INSERT statement like this instead of a movie_id value:
(SELECT id FROM movies WHERE title="E.T. the Extra-Terrestrial").