我正在使用临时报告来获取报告,我想生成完成报告。所有已注册用户的完成状态的报告。
我尝试了以下查询,但它仅给出了已完成用户的列表。它并未显示该群组中尚未完成注册的用户。请帮我解决一下这个。我想生成一个包含已注册用户(已完成和未完成)的报告。
SELECT u.username,u.firstname,u.lastname,u.email,DATE_FORMAT(FROM_UNIXTIME(p.timecompleted),'%Y-%m-%d') AS
completed,p.timecompleted
FROM prefix_course_completions AS p
JOIN prefix_course AS c ON p.course = c.id
JOIN prefix_user AS u ON p.userid = u.id
INNER JOIN prefix_cohort_members AS co ON co.cohortid=u.id
WHERE c.id=361 AND co.cohortid=142
ORDER BY u.username