title: what's wrong with this subquery
body: <p>I am trying to run a subquery to insert data into a table of a database from data gathered from a table of another database.While i run this query i am getting the following error:</p>
  <blockquote>
  <h1>1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use</h1>
  <p>near 'SELECT * FROM campaign_traffic_db.campaign_merge WHERE
  adform_clientID = 135456 ' at line 1</p>
  </blockquote>
  <pre><code>INSERT
  INTO
    135456_1257994024297010.campaign_merge(
      adform_client,
      adform_clientID,
      adform_campaign,
      adform_campaignID,
      adform_campaignStartDate,
      adform_campaignEndDate,
      adform_campaignCurrency,
      adform_cost,
      adform_clicks,
      adform_ctr,
      adform_impression,
      fb_client,
      fb_clientID,
      fb_campaign,
      fb_campaignID,
      fb_campaignStartDate,
      fb_campaignEndDate,
      fb_cost,
      fb_clicks,
      fb_impression,
      created_at,
      updated_at
    )
  VALUES (
  SELECT
    *
  FROM
    campaign_traffic_db.campaign_merge
  WHERE
    adform_clientID = '135456' AND fb_clientID = '1257994024297010')
  </code></pre>