title: how to compare values from different tables with same name mysql
body: <p>i have 2 tables</p>
  
  <p>table A </p>
  
  <pre><code>Question|Answer
  -------------------
      a   |  y
  </code></pre>
  
  <p>table B</p>
  
  <pre><code>Type  |  Question
  ------------------
    3   |   a
  ---------------
    1   |   b
  </code></pre>
  
  <p>how do i check what type question A is from Table A by looking at it from table B?
  i want to check if question a from table A is type 3 (do this) if it is type 1 (do this)
  cant find the right query </p>
  
  <pre><code>maybe Select type from table B where tableA.question = tableB.question
  </code></pre>