title: SQl query to find multiple fixtures that a user hasn’t yet predicted, but other users may have
body: <p>I have a football predictions database and I need a sql query that I can use to display all the fixtures that a specific user has not yet predicted. All predictions are kept in the UserPredictions table so a Left Join checking if the FixtureID is null will not work without another condition.</p>
  <p>I have a fixtures table with FixtureID, HomeTeam, AwayTeam &amp; FixtureStartTime as well as a UserPredictions table with UserPredictionID, UserID, FixtureID, HomeTeamPrediction &amp; AwayTeamPrediction.</p>
  <p>For example:
  There are a total of 4 fixtures.</p>
  <p>User 1 has predicted fixtures 1 &amp; 2.</p>
  <p>User 2 has only predicted fixture 2.</p>
  <p>User 3 has predicted fixtures 1-4.</p>
  <p>I want to get the fixtures that user 1 is yet to predict (3 &amp; 4), but I would like to just be able to choose the UserID and the query will display outstanding predictions based on the user.</p>
  <p>I can’t wrap my head around it.
  Thanks</p>