0 Replies Latest reply on Dec 18, 2013 7:23 AM by Sami Assi

    i can;t find the table to join

    Sami Assi

      When join tables in join tab, the table on which i want to add a left join is not available in the left drop down tables list.

      i want to add a left join between my DIM_COURSE (alias Course) table and my FACT_STUDENT_COURSE_TERM_AVERAGE (Alias Student Term Course Term Average) table

       

       

      MissingTable.jpg

       

      i can add a inner join when starting the join on the Course table as show below, but i don't want to do this because the queries will return less records.

       

      Innerjoin.jpg

       

      Please help,

      Thank you

      Sami