Join Course and Offering assignment table

Summary:

Hi,

I'm trying to create a Datamodel (basically a query) to join Course Assignment and Offering Assignment.

Both uses the same table WLF_ASSIGNMENT_RECORDS_F, just different "where clause".

Course → select * from WLF_ASSIGNMENT_RECORDS_F where LEARNING_ITEM_TYPE = 'ORA_COURSE'

Offering → select * from WLF_ASSIGNMENT_RECORDS_F where LEARNING_ITEM_TYPE = 'ORA_CLASS'

And then I use WLF_LI_CLASSES_F to get the relationship between Course and Offering.

This is how I join originally.

select 'COURSE', A.ASSIGNMENT_RECORD_NUMBER as COURSE_ASSIGNMENT_RECORD_NUMBER, A.LEARNING_ITEM_ID as COURSE_LEARNING_ITEM_ID
,B.LEARNING_ITEM_ID as WLF_LI_CLASSES_F_LEARNING_ITEM_ID