title: mysql concat on columns name
body: <p>hi I'm just starting to learn sql and I wish to combine the columns into one using concat but didn't manage to do it. I can run the code without concat but when when I use concat it gives me an error code. Can anyone tell me what am I doing wrong?</p>
  
  <pre><code>SELECT CONCAT('A purchase with the purchase ID of' AS "Constraint",
  ONLINEPURCHASE.PurchaseID AS "OLID", 'is an online purchase of type' AS "Condition", ONLINEPURCHASE.OnlineType AS "OLType", 'and also a walkin purchase of location' AS "Condition", WALKINPURCHASE.ShopLocation AS "ShopLocation") 
  FROM ONLINEPURCHASE JOIN WALKINPURCHASE
      ON ONLINEPURCHASE.PurchaseID = WALKINPURCHASE.PurchaseID
  WHERE WALKINPURCHASE.PurchaseID IN (SELECT PurchaseID
          FROM WALKINPURCHASE);
  </code></pre>
  
  <p>But got this error (ERROR 1583 (42000): Incorrect parameters in the call to native function 'concat') </p>