문서의 이전 판입니다!
SELECT MB.MCode, MB.MName, COUNT(DISTINCT ItemCode) FROM TB_Member MB, TB_StudyPlan SP WHERE MB.TCode = ? AND MB.ACode = ? AND SP.MCode = MB.MCode AND MB.MCode > 0 AND MB.IsActive = 1 AND SP.StudyPlanYMD Between ? AND ? ;
SELECT MB.MCode, MB.MName, COUNT(DISTINCT ItemCode) FROM TB_Member MB, TB_StudyPlan SP WHERE MB.TCode = ? AND MB.ACode = ? AND SP.MCode = MB.MCode AND MB.MCode > 0 AND MB.IsActive = 1 AND SP.StudyPlanYMD Between ? AND ? ;
SELECT MB.MCode, MB.MName, COUNT(DISTINCT ItemCode) FROM TB_Member MB, TB_StudyPlan SP WHERE MB.TCode = ? AND MB.ACode = ? AND SP.MCode = MB.MCode AND MB.MCode > 0 AND MB.IsActive = 1 AND SP.StudyPlanYMD Between ? AND ? ;