SQL: List All Merged Blackboard Courses

Summary

This query lists the parent and child course names of merged courses and is filtered by Course ID.

Data Source: Blackboard Learn DDA on SaaS

Code

SELECT cmp.course_name as parent_course, cmc.course_name as child_course
FROM PUBLIC.course_course cc
LEFT JOIN PUBLIC.course_main cmc
ON cmc.pk1 = cc.crsmain_pk1
LEFT JOIN PUBLIC.course_main cmp
ON cmp.pk1 = cc.crsmain_parent_pk1
WHERE cmc.course_id LIKE '%.202040' -- Filter by course ID
AND cmc.row_status = '0' -- Only Active Courses
AND cmp.row_status = '0' -- Only Active Courses