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
solved 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
solved Can we use CONCAT and JOIN together in MySQL? [closed]