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. And verify which you’ve given them the right quantity so they can enter touch along with you quick loans no credit checks that is a bit more interest when compared to a mortgage, car loans, school loan, or personal loan.

2. 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.