title: INSERT multiple rows INTO one table, with each record's columns having different reference values
body: <p>I have three tables: </p>
  
  <blockquote>
    <p>Movie [mID, title, year, director]<br>
    Rating [rID (foreign key), mID (foreign key), stars, ratingDate]<br>
    Reviewer [rID, name]</p>
  </blockquote>
  
  <p>I have to insert, into table Rating, a review by "James" (present in table Reviewer) giving 5 stars to every movie in the database, leaving the ratingDate as "NULL"</p>
  
  <p>So far I've been able to JOIN James's rID with every mID in table Movie. </p>
  
  <pre><code>SELECT * FROM (SELECT rID FROM reviewer WHERE name = "James") AS a LEFT JOIN (SELECT mID FROM movie) AS b ON 1=1;
  </code></pre>
  
  <p>What I don't know is how to add the 5 stars and NULL ratingDate to each one of those entries, and finally append all those to my Rating table.</p>
  
  <p>My question is if it can all be done in one query (with multiple subqueries I imagine), or if I'm taking the wrong approach. It seems like a relatively simple problem but I can't wrap my head around it.</p>