moonjazz Posted October 31, 2011 Share Posted October 31, 2011 is it possible to do that? example : IF $ClassSize=$HeadCount THEN UPDATE course SET Status = 'close'; Quote Link to comment Share on other sites More sharing options...
trq Posted October 31, 2011 Share Posted October 31, 2011 Yes. Quote Link to comment Share on other sites More sharing options...
moonjazz Posted October 31, 2011 Author Share Posted October 31, 2011 i realized UPDATE course p INNER JOIN courseschedule pp ON p.CourseID = pp.CourseID SET p.Status = 'Closed' WHERE pp.HeadCount = p.ClassSize does the same thing. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.