Database query

SELECT ARE.ID ,
            A.FirstName ,A.LastName, ARE.RoundID, ARE.AdmIVEvalCriteriaID, IVC.IVEvalCriteria, ARE.PointsScored
        FROM Employee ARE
        INNER JOIN Round A ON ARE.plicationID = A.ID
        INNER Join ICompany IVC ON ARE.AdmIVEvalCriteriaID = IVC.ID
        WHERE ARE.ID= A.EmpID and A.AdmissionID = ARE.AdmID AND ARE.RoundID IVRoundID
        ORDER BY ARE.RoundID, AdmApplicationID;