SQL Query to extract the newest student photo file from the iSAMS database

studentPhotos.sql

-- SQL Script to get the latest student photos out of iSAMS
SELECT txtEmailAddress, 
  (SELECT TOP (1) txtPath FROM TblPupilManagementPictures 
    WHERE (txtSchoolID = TblPupilManagementPupils.txtSchoolID) 
  ORDER BY intOrder DESC) AS txtPupilPicturePath 
  FROM TblPupilManagementPupils 
WHERE (intSystemStatus = '1') AND 
  ((SELECT TOP (1) txtPath 
  FROM TblPupilManagementPictures AS TblPupilManagementPictures_1 
  WHERE (txtSchoolID = TblPupilManagementPupils.txtSchoolID) 
  ORDER BY intOrder DESC) 
IS NOT NULL)