UPDATE: Nevermind. Error was with the developer.

I get an error if I add the cPatientNumber line that PatientNumber cannot be found. I thought this was allowed. There will only be one record ever in the result and I want the specific value of cPatientNumber in that column.

SELECT ;
	cPatientNumber AS PatientNumber, ;
	ALLTRIM(pt.ptLName) AS PatientLastName, ;
.
.
.