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

How useful was this post?

Click on a star to rate it!

Average rating 5 / 5. Vote count: 1

No votes so far! Be the first to rate this post.

Eric Silva

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

Advertisement

Add comment

Leave a Comment

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

Advertisement

Categories

Advertisement