[Solved] Cannot find sql syntax error [closed]

You have a comma too much at the end here:

$sqlPrescriptionQuery .= "concat(tas.vch_first_name, ' ', tas.vch_last_name) as vch_resource_name, ";

It should be:

$sqlPrescriptionQuery .= "concat(tas.vch_first_name, ' ', tas.vch_last_name) as vch_resource_name ";