Hi,
please see screen shot,below
screen shot
http://www.dotnetspider.com/attachments/forum/334710-2161-update2.png
SELECT CourseID,CRModuleId,CRModule_Name,CRModule_LevelId,CRModule_RefCourseId,CRModule_RefCourseName
FROM CR_Modules
INNER JOIN CR_Levels on CRModule_LevelId = CRLevelID
INNER JOIN Course on CourseID = CRLevel_CourseId
Where CourseID=5273
CourseID CRModuleId CRModule_Name CRModule_LevelId CRModule_RefCourseId CRModule_RefCourseName
5244 32 Module 1 476581 1 Course 1
5244 33 Module 2 476816 1 Course 1
5244 33 Module 3 476817 1 Course 1
5244 33 Module 4 476818 1 Course english
5244 33 Module 5 476819 1 Course english
5273 40 test Level1 477114 31 test Maths
5273 41 test Level2 477115 31 test Maths
5273 42 test Level3 477116 31 test Maths1
5273 43 test Level4 477117 31 test Maths1
*****************************************************************
i need update query same name (CRModule_RefCourseName) i add to number + 1,
CRModule_RefCourseId .
I want edit this query? for this condition
update CR_Modules set CRModule_RefCourseId = (select (max(CRModule_RefCourseId)+1) CRModule_RefCourseId
FROM CR_Modules
INNER JOIN CR_Levels on CRModule_LevelId = CRLevelID
INNER JOIN Course on CourseID = CRLevel_CourseId
Where CourseID=5273
)
from CR_Modules
INNER JOIN CR_Levels on CRModule_LevelId = CRLevelID
INNER JOIN Course on CourseID = CRLevel_CourseId
Where CourseID=5273
thanks,
karthikeyan