Blackboard Learn Logo
Home » Blackboard » Blackboard Learn » SQL Queries » SQL: List All Merged Blackboard Courses

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 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

Eric Silva

Eric is a Systems Analyst at The University of Texas at San Antonio and a graduate from Boise State University. Learn more about me.

Add comment

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.