select Patient_ID,concat(First_Name_M0040,' ',Last_Name_M0040) as patientname from #Request.prefix_db_agency#.patient where First_Name_M0040="john"

#Patient_ID# #patientname#