SELECT Employee_T.Employee_num,  avg([4Salary(봉급작년과비교)].rate)
FROM ((Training_course INNER JOIN Training_history ON Training_course.Course_num = Training_history.Course_num) INNER JOIN Employee_T ON Training_history.Employee_num = Employee_T.Employee_num) INNER JOIN [4Salary(봉급작년과비교)] ON Employee_T.Employee_name = [4Salary(봉급작년과비교)].empid
WHERE (((Training_history.Employee_num) Not In (SELECT DISTINCT Training_history.Employee_num
FROM Training_course, Training_history
WHERE Training_history.Course_num = Training_course.Course_num AND
          Training_course.Course_type = "off-line";)))
GROUP BY Employee_T.Employee_num

이렇게 벌써 서브쿼리 써서 만들어 낸 쿼리 자체를 AS A 를 써서
알리아스 테이블로 만들 수 있나요?
AS A를 써보겠습니다

예시)

SELECT AVG(A.(avg([4Salary(봉급작년과비교)].rate)))
FROM
(SELECT Employee_T.Employee_num,  avg([4Salary(봉급작년과비교)].rate)
FROM ((Training_course INNER JOIN Training_history ON Training_course.Course_num = Training_history.Course_num) INNER JOIN Employee_T ON Training_history.Employee_num = Employee_T.Employee_num) INNER JOIN [4Salary(봉급작년과비교)] ON Employee_T.Employee_name = [4Salary(봉급작년과비교)].empid
WHERE (((Training_history.Employee_num) Not In (SELECT DISTINCT Training_history.Employee_num
FROM Training_course, Training_history
WHERE Training_history.Course_num = Training_course.Course_num AND
          Training_course.Course_type = "off-line";)))
GROUP BY Employee_T.Employee_num ) AS A

이런 식으로 하면 안되던데, 제가 잘못 생각하고 있는건가요,,
개초보입니다 흑흑