I am trying to select the firstname and surname fields from a table.
select firstname + surname fullname from people;This does work in other databases but does not seem to work here. Am I doing something wrong or is there a different way to achieve this with mysql? Michael
