查询什么才能找到否。在MOODLE完成课程的学生有多少?我正在使用以下查询:
$user_id mu.id as student_id,count(mcc.course) as completed_course from mdl_user mu.id mdl_course_completionsmcc on mcc.userid=mu.id JOIN mdl_course mc on mc.id=mcc.course WHERE mcc.userid =$user_id
我正在进行一个连接到表A和B的查询。、20032等)SELECT A.TAP, A.Operator, SWITCH(B.MCC='10020', 'Own Network', B.MCC, A.Zone) FROM ALEFT JOIN B ON A.TAP=B.TAP
查询结果显示所有区域值的#Error值。我认为这是由于MCC是数字格式的,因为当我将MCC更改为短文本(虽然没有文本,只有数字)时,查询会转储正
2| 49、230、3WHERE 1 = 1AND r.client_id IN (3,3,49,49)AND r.mnc IN (68,69,2,3)
如何获得这样的结果:client_id = 3 AND mcc= 204 AND mnc = 68 also client_id = 3 AND mcc = 204 AND mnc = 69 thai is al