左连接查询中两列的连续

Question

$select->columns(array('TableReservationId', 'TableId', 
                       'ReservationDate', 'StartTime', 
                       'NumberOfGuests', 'AdditinalInfo', 
                       'StaffID', 'MerchantId', 'cust_id'
                       )
                 );

$select->join($cus, "$dtr.cust_id=$cus.cust_id", 
                    array('cust_firstName','cust_lastName'),
                    'left');

$select->join($mer, "$dtr.MerchantId=$mer.MerchantId", 
                     array('FirstName','LastName'),
                    'left');

$select->join($staff, "$dtr.StaffID=$staff.StaffID", 
                      array('FirstName','LastName'),
                      'left');

this is my query i want concat (FirstName,'' ,LastName ) as customer_name concat (FirstName,'' ,LastName ) as Employee_name how can i do this ?

Answer 1

can you not just have it in the select? such as:

(FirstName + '' + LastName) as Employee_Name