title: How to return all objects associated with a user that are all in another table too with MYSQL
body: <p>I'm doing a electric-scooter project (school project) like LIME and I need to return the result of a certain query (see below) </p>
  
  <p>I'm using MYSQL 5.7.24, and I have already try a hundred of queries with no good matching result.
  I have 2 tables for this query: 
  Trips Table that contains userID, scooterID and other rows.
  Reload Table that contains userID, scooterID and other rows.</p>
  
  <p>My query is supposed to return the list of users that have used all the scooters they have loaded.</p>
  
  <p>The actual problem is "that have used ALL the scooters...".</p>
  
  <p>Here is an example of not working query:</p>
  
  <pre><code>SELECT r.userID
  FROM reload r
  LEFT JOIN trips v
  ON r.useID= v.`userID` AND r.scooterID= v.scooterID WHERE r.`scooterID ` IS NOT NULL
  GROUP BY r.userID
  </code></pre>
  
  <p>Example:</p>
  
  <p>If user X use scooter A,B and reload scooter A,B. My query is supposed to return the userID of user X.</p>
  
  <p>Now, if user X use scooter A,B and reload scooter A,B,C. My query is supposed to NOT return the userID of user X.</p>