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