3 Replies Latest reply on Sep 13, 2019 6:27 PM by Glen Conway

    Switching your SQL from Oracle to ANSI Style

    Ümit ŞAMLI

      watched video and tried it. if there is a comment line, bottom code is deleted.

       

      SELECT d.department_name,
             e.employee_name
        FROM departments   d,
             employees     e
       WHERE d.department_id = e.department_id
         AND d.department_id >= 30
         --AND d.department_id >= 30
       ORDER BY d.department_name;
      

       

      Toogle Ansi/ORACLE Join

       

      SELECT d.department_name,
             e.employee_name
        FROM departments   d
       INNER JOIN employees     e ON d.department_id = e.department_id
       WHERE d.department_id >= 30
      

       

       

      using :