SELECT (TransferSubject) AS Subject, TransferCourse, TransferCourseNumber, EffectiveTerm, EquivalentCourse, EquivalentSubject, EquivalentCourseNumber, CreditsUsed FROM maintable WHERE FK_Institution = '' AND `Group` = '' ORDER BY Subject, TransferCourseNumber ASC