3 Replies Latest reply: Aug 27, 2014 8:30 AM by gurjeet singh RSS

    common field between two tables

      i have below data in script

       

       

      LOAD EMPNO,

          ENAME,

          JOB,

          MGR,

          date(HIREDATE,'MMM') as mon,

              date(HIREDATE,'YYYY') as year,

          SAL,

          COMM,

          DEPTNO,

          "DATE_UPDATED";

      SQL SELECT *

      FROM SCOTT.EMP;

       

      mon:

      load * inline [

      no, mon

      1,Jan

      2,Feb

      3,Mar

      4,Apr

      5,May

      6,June

      7,Jul

      8,Aug

      9,Sep

      10,Oct

      11,Nov

      12,Dec

      ];


      Untitled.jpg

       

      as u can see above image

      2.part -  if i select the month - number are summing up fine.

      3.part - if u select the month from inline table - number are not summing up fine.

      4.part - data model

       

       

      forst of all i want only distinct month in list box. but it is showing from both tables.

      I havn't use join between two tables, if i use left outer join it is working fine.

       

       

      How can i get the distinct month in list box with out using "left join"?????

       

       

      thanks