Combine Strings – CONCAT

SELECT a.`id`, a.`event_id`, a.`first_name`, a.`last_name`, a.`mobile`, 
a.`appointment_time`, a.`deleted`, a.`updated_time`, 
concat(b.`title`, ' ', b.`first_name`, ' ', b.`last_name`) as `doctor_name`
FROM `customers` as a
join `doctors` as b on b.`id` = a.`doctor_id`
WHERE `appointment_time` between '2012-12-1' and '2013-1-1'

2 thoughts on “Combine Strings – CONCAT

  1. This is really attention-grabbing, You are a
    very skilled blogger. I have joined your rss feed and look ahead
    to seeking more of your magnificent post. Also,
    I have shared your web site in my social networks

Comments are closed.