Can we use CONCAT and JOIN together in MySQL? [closed]

Yes you can. Try something like this:

SELECT a.ID, CONCAT(a.name,' ',b.surname) AS FULL_Name
  FROM table_a a JOIN table_b b
    ON a.ID = b.ID

See this SQLFiddle