ExcelStore

Примеры команд SQL в рамках урока #18

Oct 20th, 2020 (edited)
1,041
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. --Примеры команд SQL в рамках урока #18
  2.  
  3. SELECT * FROM DEPARTMENTS_2
  4. ;
  5.  
  6. SELECT
  7.     a.*, b.DEPARTMENT_NAME
  8. FROM
  9.     EMPLOYEES a
  10.     INNER JOIN DEPARTMENTS_2 b ON a.DEPARTMENT_ID = b.DEPARTMENT_ID
  11. ;
  12.  
  13. SELECT
  14.     a.*, b.DEPARTMENT_NAME
  15. FROM
  16.     EMPLOYEES a
  17.     LEFT OUTER JOIN DEPARTMENTS_2 b ON a.DEPARTMENT_ID = b.DEPARTMENT_ID
  18. ;
  19.  
  20. SELECT
  21.     a.*, b.DEPARTMENT_NAME
  22. FROM
  23.     EMPLOYEES a
  24.     LEFT OUTER JOIN DEPARTMENTS b ON a.DEPARTMENT_ID = b.DEPARTMENT_ID
  25. ;
  26.  
RAW Paste Data