Versions Compared

Old Version 6

changes.mady.by.user Vladimir Ozerov Ozerov

Saved on

compared with

New Version 7

changes.mady.by.user Vladimir Ozerov Ozerov

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagesql
titleAfter
linenumberstrue
SELECT emp.name, dept.name
FROM emp, dept
WHERE emp.salary>1000 AND emp.dept_id=dept.id

dfExample 2: JOIN conversion for FROM clause

Code Block
languagesql
titleBefore
linenumberstrue
SELECT emp.name, dept_subquery.name
FROM emp, (SELECT * FROM dept WHERE state='CA') dept_subquery
WHERE emp.salary>1000 AND emp.dept_id=dept_subquery.id

...