Changes between Version 5 and Version 6 of AdvancedDatabaseDevelopment

Timestamp:

08/07/26 16:19:18 (23 hours ago)

Author:

231175

Comment:

--

AdvancedDatabaseDevelopment

@@ -98 +98 @@
     e.enrollment_id AS enrollment_id,
     u.user_id AS user_id,
-    u.name AS user_name,
+    a.name AS user_name,
     c.course_id AS course_id,
     ct.title_short AS course_title,
@@ -108 +108 @@
 FROM enrollment e
 JOIN "user" u ON e.user_id = u.user_id
+JOIN account a ON a.id = u.account_id
 JOIN course_version cv ON e.course_version_id = cv.course_version_id
 JOIN course c ON cv.course_id = c.course_id