No Patient Visit Details Available. SELECT pvd2.*,si.Visit_Date FROM #Request.prefix_db_agency#.pProgress pvd1 LEFT OUTER JOIN #Request.prefix_db_agency#.pProgress pvd2 on pvd1.Assmt_ID = pvd2.Assmt_ID LEFT OUTER JOIN #Request.prefix_db_agency#.pSchedules si ON pvd2.Schedule_ID = si.Schedule_ID WHERE pvd1.Progress_ID = #url.PVDID# AND pvd1.Description = pvd2.Description ORDER BY Visit_Date Click a Point on the Graph to get detailed information.