SELECT AttID ,SessionDate , CONCAT( FirstName, " ", LastName ), Present
FROM myTable
----- Original Message -----
From: "GH" <garyhotko@stripped>
To: <mysql@stripped>
Sent: Sunday, November 14, 2004 5:32 AM
Subject: Concatinating Two Columns
> I would like to know how I can make two columns out put as one?
>
> For Example I have
>
> +-------+-------------+----------+-----------+---------+
> | AttID | SessionDate | LastName | FirstName | Present |
> +-------+-------------+----------+-----------+---------+
> | 2 | 2004-10-30 | Smith | Dale | Yes |
> +-------+-------------+----------+-----------+---------+
>
> I would like to have it output as
>
> +-------+-------------+----------------------+---------+
> | AttID | SessionDate | Name | Present |
> +-------+-------------+----------------------+---------+
> | 2 | 2004-10-30 | Dale Smith | Yes |
> +-------+-------------+----------+-----------+---------+
>
