Learn Module | SQL query to get specialization details , module name, offering name, enrolled learne
I am working on a report where I need to fetch specialization details and its' corresponding module name, offering name, enrolled learners, current status of offering, enrollment date.
I have a query where I am able to fetch offering name, enrolled learners name, current status of offering.
I have a query where I am able to fetch specialization name.
I need input to get the above details in a single query.
I need input to establish a link between the three separate queries.
/* Offering Details Code*/ select WLFI.LEARNING_ITEM_NUMBER ,TO_CHAR(WLFI.EFFECTIVE_START_DATE,'YYYY/MM/DD') Offer_Eff_Start_Dt ,WLFT.NAME ,WLFI.LI_START_DATE Offer_Start_Date ,PPNF.FULL_NAME EMPLOYEE_NAME ,PPSL.PERSON_NUMBER ,COURSE_NAME.NAME AS COURSE ,WLFI.STATUS FROM WLF_LEARNING_ITEMS_F WLFI, WLF_LI_COURSES_F WLCF, WLF_LI_CLASSES_F WLCLF, WLF_LEARNING_ITEMS_F_TL WLFT, PER_PERSON_SECURED_LIST_V PPSL, WLF_ASSIGNMENT_RECORDS_F ASSGT, PER_PERSON_NAMES_F PPNF, (SELECT LIF1.NAME, LCF.LEARNING_ITEM_ID FROM WLF_LEARNING_ITEMS_F_VL LIF1, WLF_LI_CLASSES_F LCF WHERE LIF1.LEARNING_ITEM_ID = LCF.COURSE_LEARNING_ITEM_ID AND TRUNC(SYSDATE) BETWEEN LIF1.EFFECTIVE_START_DATE AND