To join (concatenate) two columns in SQL:

In MySQL / PostgreSQL / most SQLs (using || or CONCAT) :

SELECT first_name || ' ' || last_name AS full_name FROM your_table_name;

However, in MySQL specifically, you use CONCAT function:

SELECT CONCAT(first_name, ' ', last_name) AS full_name FROM your_table_name;