SELECT AttID ,SessionDate , CONCAT( FirstName, " ", LastName ), Present FROM myTable
----- Original Message ----- From: "GH" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> 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 | > +-------+-------------+----------+-----------+---------+ > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]