Showing posts with label php concat of two colums in left join query. Show all posts
Showing posts with label php concat of two colums in left join query. Show all posts

concat of two colums in left join query

Wednesday, November 4, 2015
$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 ?

concat of two colums in left join query

$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 ?