select Patient_ID,concat(First_Name_M0040,' ',Last_Name_M0040) as patientname from #Request.prefix_db_agency#.patient where First_Name_M0040="john" limit 0,5 select Agency_ID,Employee_ID,Record_creation_Date,concat(Last_Name,' ',First_Name) as employeename from #Request.prefix_db_lookup#.Employee where First_Name="charles" limit 0,5 select distinct Record_creation_Date from #Request.prefix_db_lookup#.Employee limit 0,5
Available Time:#dateform.Record_creation_Date#
select Agency_ID,Employee_ID,concat(Last_Name,' ',First_Name) as employeename from #Request.prefix_db_lookup#.Employee where Record_creation_Date=#dateform.Record_creation_Date#
#divdateform.employeename#
select Agency_ID,Employee_ID,concat(Last_Name,' ',First_Name) as employeename where Record_creation_Date=#dateform.Record_creation_Date#
#divdateform.employeename#
Form.chkemployee