How to add multiple concat in one query?

November 22, 2021

SELECT CONCAT(schedule, ' ', starttime) as timestamp  
from tblappointment

SELECT a.*, CONCAT(p.fname,' ',p.lname) AS pname 
FROM tblappointment a,tblpatient p 
WHERE p.id = a.patient_id

I want to combine them into one query. I don’t know how to convert that code using subquery

>Solution :

You can add additional ones using commas. Make sure the column name timestamp isn’t already declared. You may want to consider using joins and GROUP BY to avoid duplicate records.

SELECT 
a.*, 
CONCAT(p.fname,' ',p.lname) AS pname,
CONCAT(a.schedule, ' ', a.starttime) as timestamp  
FROM tblappointment a,tblpatient p 
WHERE p.id = a.patient_id