title: SQL statements In Access Database
body: <p>I have attached the 3 tables I have below. </p>
  
  <p>Trainers table  </p>
  
  <p><img src="https://i.stack.imgur.com/njF7f.jpg" alt="enter image description here"></p>
  
  <p>TrainerPlan Table</p>
  
  <p><img src="https://i.stack.imgur.com/YRZrg.jpg" alt="enter image description here"></p>
  
  <p>FitnessPlans Table</p>
  
  <p><img src="https://i.stack.imgur.com/m4RWh.jpg" alt="enter image description here"></p>
  
  <p>So what I am trying to do is show the FirstName, LastName, Phone, and Hours of all trainers who have a particular PlanID. So I tried</p>
  
  <pre><code>SELECT FirstName, LastName, Phone, Hours
  FROM TRAINERS T INNER JOIN TRAINERPLAN TP
  ON T.ID = TP.TrainerID
  INNER JOIN FITNESSPLANS FP
  ON TP.PlanID = FP.ID
  WHERE FP.ID = 1;
  </code></pre>
  
  <p>I get the error:</p>
  
  <p><img src="https://i.stack.imgur.com/cWYYZ.jpg" alt="enter image description here"></p>
  
  <p>What am I doing wrong? I have done sql in sql developer and this is how I would do it. I'm pretty sure access sql is not exactly the same, but if I run:</p>
  
  <pre><code>SELECT FirstName, LastName, Phone, Hours
  FROM TRAINERS T INNER JOIN TRAINERPLAN TP
  ON T.ID = TP.TrainerID;
  </code></pre>
  
  <p>This runs successfully and shows results, so I know the inner joining is working, but I just can't get another inner join on there for some reason. </p>