title: Selecting values from two columns and concatenating them into a column on a different table
body: <p>I'm a bit new to SQL and trying to do what my description above says. This below is my query:</p>
  
  <pre><code>SELECT
       CONCAT (first_name, last_name) INTO full_name_variable
  FROM
      table_1
  WHERE
      phone_number = new.number;
  </code></pre>
  
  <p>It doesn't seem to work. However, when I use this query using <code>AS</code> it works. Like this:</p>
  
  <pre><code>SELECT
        CONCAT (first_name, last_name) AS full_name_variable
  FROM
        table_1
  WHERE
      phone_number = new.number;
  </code></pre>
  
  <p>I'd really appreciate the help</p>