— Returns the courses and assignment title for SafeAssignments, embedded into the Assignment tool (New Method SafeAssign) — basic query found somewhere, and modified to pull GM.TITLE SELECT cm.COURSE_ID,cm.course_name,gm.title FROM COURSE_MAIN cm JOIN mdb_safeassign_item msi ON (msi.crsmain_pk1 = cm.PK1) JOIN gradebook_main gm ON gm.pk1 = msi.GRADEBOOK_MAIN_PK1 — WHERE cm.course_id LIKE ‘%1169%’ ORDER by cm.course_id; ]]>
