title: MySQL join tables and extract data
body: <p>I am new to MySQL I want to extract columns from two different tables</p>
  
  <p>like I want title from table1 and body from table2</p>
  
  <p>I am trying</p>
  
  <pre><code>SELECT `title` from node INNER JOIN  `body` from node_revisions
  </code></pre>
  
  <p>it gives error: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from node_revisions
  LIMIT 0, 25' at line 1 </p>