Edit

Order

Name

Query SELECT pp.Last, pp.First, pp.PatientProfileId, pv.TicketNumber, pvp.PatientVisitProcsId, pvp.DateOfEntry, pvp.CPTCode, pvp.Description, pvp.Units, pvp.Fee, pvp.TotalFee, pvp.Allowed , pvp.TotalAllowed FROM PAtientVisitProcs pvp LEFT JOIN PatientVisit pv ON pv.PatientVisitId = pvp.PatientVisitId LEFT JOIN PatientProfile pp ON pp.PatientProfileId = pv.PatientProfileId WHERE pvp.ProceduresId = (select ProceduresID from Procedures where cptcode='J0879')

Notes