1 Reply Latest reply on Apr 9, 2015 7:42 AM by zakir.idb.bd

    Problem when joining

    2926453

      Hello,

       

      I am lucky and i am new to oracle.

      I need to retrieve the data from emp table and dept table based on given input deptno and JOB

      >SELECT

      ENAME, E.DEPTNO, JOB , LOC FROM

      EMP E , DEPT D where e.deptno=&dno and job ='&JOB' ;

      if i enter 10 and clerk

      If i write query like this it needs to diplay only MILLER Record only but the output like as below

       

      MILLER    10    CLERK    NEW YORK

      MILLER    10    CLERK    DALLAS

      MILLER    10    CLERK    CHICAGO

      MILLER    10    CLERK    BOSTON

       

      Please help me on this.