what is wrong
SELECT m_name, m_status, p_num, p_date, g_code GROUP_CONCAT(g_code)
       FROM (SELECT D.m_name, D.m_status, A.p_num, A.p_date, C.g_code FROM post A LEFT OUTER JOIN postgoods B ON A.p_num = B.p_num LEFT OUTER JOIN goodscode C ON B.g_num = C.g_num JOIN member D ON A.m_num = D.m_num ORDER BY A.p_date desc)
       GROUP BY p_num

I do not know whether this code where the error


what is wrong
===

SELECT m_name, m_status, p_num, p_date, g_code GROUP_CONCAT(g_code)
       FROM (SELECT D.m_name, D.m_status, A.p_num, A.p_date, C.g_code FROM post A LEFT OUTER JOIN postgoods B ON A.p_num = B.p_num LEFT OUTER JOIN goodscode C ON B.g_num = C.g_num JOIN member D ON A.m_num = D.m_num ORDER BY A.p_date desc)
       GROUP BY p_num

I do not know whether this code where the error

