뷰쿼리 인데요 속도도 엄청느리구요 ER-STUDIO에서도 뷰쿼리에 에러있다 나옵니다.
ALTER VIEW dbo.vw_member_point_list
AS
SELECT m_idx, m_code, g_code, m_class, m_name, m_id, m_updateday,
(SELECT TOP 1 c_point
FROM u030054.el_check
WHERE m_idx = u030054.EL_member.m_idx AND c_point is not NULL
ORDER BY c_idx DESC) AS m_point,
(SELECT TOP 1 c_step
FROM u030054.el_check
WHERE m_idx = u030054.EL_member.m_idx
ORDER BY c_idx DESC) AS c_step,
(SELECT TOP 1 c_month
FROM u030054.el_check
WHERE m_idx = u030054.EL_member.m_idx
ORDER BY c_idx DESC) AS c_month,
(SELECT TOP 1 c_time
FROM u030054.el_check
WHERE m_idx = u030054.EL_member.m_idx
ORDER BY c_idx DESC) AS c_time,
(SELECT TOP 1 c_check_day
FROM u030054.el_check
WHERE m_idx = u030054.EL_member.m_idx
ORDER BY c_idx DESC) AS c_check_day, m_academy,
m_consent
FROM u030054.EL_member |