title: Problems with inner join SQL
body: <p>Basically i am working with 2 tables, one is the cars and one is comments and i am trying to get the count of approved comments for certain cars + the cars information, but i would like it to be dynamic if i put in the id of the car directly it will work but when i say where id = car id it returns nothing?</p>
  
  <p>This works with "10" it will give me the information + the count of comments</p>
  
  <pre><code>SELECT t1.biler_id, t1.biler_navn, COUNT(t2.bilbixen_commentary_status) 
  FROM bilbixen_biler t1 
  INNER JOIN bilbixen_commentary t2 ON t1.biler_id = t2.bilbixen_commentary_bil
  WHERE t1.biler_id = 10
  </code></pre>
  
  <p>The above query will return this in phpmyadmin
  <a href="https://i.stack.imgur.com/mGt4D.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/mGt4D.png" alt="enter image description here"></a></p>
  
  <p>The below query don't work, i am trying to tell it to find everything where t1.id is equal t2.id</p>
  
  <pre><code>SELECT t1.biler_id, t1.biler_navn, COUNT(t2.bilbixen_commentary_status) 
  FROM bilbixen_biler t1 
  INNER JOIN bilbixen_commentary t2 ON t1.biler_id = t2.bilbixen_commentary_bil
  WHERE t1.biler_id = t2.bilbixen_commentary_bil
  </code></pre>
  
  <p>The above query will give me this error in phpmyadmin
  <a href="https://i.stack.imgur.com/bRHmL.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/bRHmL.png" alt="enter image description here"></a></p>
  
  <p>I expected it to return all the information for each car with a count of comments for each of them</p>