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 | +-------+-------------+----------+-----------+---------+ I have the following: mysql> \s -------------- mysql Ver 12.22 Distrib 4.0.18, for mandrake-linux-gnu (i586) Server version: 4.0.18 Protocol version: 10 Connection: Localhost via UNIX socket Client characterset: latin1 Server characterset: latin1 UNIX socket: /var/lib/mysql/mysql.sock Uptime: 2 days 8 hours 8 min 48 sec Threads: 2 Questions: 10654 Slow queries: 0 Opens: 123 Flush tables: 1 Open tables: 30 Queries per second avg: 0.053 -------------- Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]