Hello. I'm using MySQL with .NET, and I'm having an issue with writing a query that will combine two columns into one result set. This is much like the Microsoft way of doing:
SELECT LastName + ' ' + FirstName FROM tbl1
So the result would be
Doe Jane
Doe John ...
I can't imagine this is impossible to do in MySQL, so are there any ideas? Many thanks!
Bryan
SELECT LastName + ' ' + FirstName FROM tbl1
So the result would be
Doe Jane
Doe John ...
I can't imagine this is impossible to do in MySQL, so are there any ideas? Many thanks!
Bryan