Concatenate columns in SQL

Syntax:

SELECT Concat(Field1,Field2) From Tablename

concat(firstname, lastname)

SELECT e.Emp_Id,Concat(e.fir_name,',',e.Las_name) as Fir_name FROM  emp_detail e,emp_off_detail e1 where e.Emp_ID=e1.Emp_ID