문서의 이전 판입니다!
:set
:set encoding
:set encoding=utf-8
:syntax on
:syntax off
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 ? ;