title: innerjoin or another way to combine data
body: <p>Out of a database I am trying to combine two tables into one search query.</p>
  
  <p>Table1: faq</p>
  
  <pre><code>| faq_id | title | status | url_key |
  | ------ | ----- | ------ | ------- |
  |   1    | Test  |   1    | go.html |
  </code></pre>
  
  <p>Table2: faq_value</p>
  
  <pre><code>| faq_value_id | faq_id | attribute  | value          |
  | ------------ | ------ | ---------  | -------        |
  |      1       |    1   |  metakey   | testing        |
  |      2       |    1   |  metadesc  | this is a test |
  |      3       |    1   | meta_image | test.jpg        |
  </code></pre>
  
  <p>Now my desired query result would look like this:</p>
  
  <pre><code>| faq_id | title | status | metadesc  | metakey | meta_image | url_key |
  | ------ | ----- | ------ | --------  | ------- | ---------- | ------- |
  |   1    | Test  |   1    | this is a | testing | test.jpg   | go.html |
  </code></pre>
  
  <p>My attempt so far has failed:</p>
  
  <pre><code>SELECT 
  faq.faq_id,faq.title,status,
  (SELECT faq_value.value AS metadesc WHERE faq_value.attribute_code = 'metadesc'),
  (SELECT faq_value.value AS metakey WHERE faq_value.attribute_code = 'metakey'),
  (SELECT faq_value.value AS meta_image FROM faq_value WHERE faq_value.attribute_code = 'meta_image')
  faq.url_key,
  FROM faq
  INNER JOIN faq_value ON faq_value.faq_id = faq.faq_id
  </code></pre>
  
  <p>I am sure I am just overlooking something silly, but just cannot spot is. This one kicks a SQL error:</p>
  
  <pre><code>#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 'WHERE faq_value.attribute_code = 'metadesc'), (SELECT faq_value.value AS metakey' at line 2
  </code></pre>