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.