While working on a project, I was looking for a way to join to mysql columns without using php or .net. This function is called 'concat' and allows you to join together 2 columns as one.
Here is the code:
SELECT CONCAT(firstname, ' ', lastname) As fullname FROM table1 ....
Hope it helps someone.