„Join (SQL)“ – Versionsunterschied
| [ungesichtete Version] | [ungesichtete Version] |
Inhalt gelöscht Inhalt hinzugefügt
K Reverted edits by 72.37.244.124 (talk) to last revision by 119.82.127.168 (HG) |
→Equi-join: fixed a layout issue with missing end and begin source markup |
||
Zeile 127:
FROM employee
JOIN department ON employee.DepartmentID = department.DepartmentID;
</source>
We can write equi-join as below,
SELECT * FROM employee ,department WHERE employee.DepartmentID = department.DepartmentID;▼
<source lang=sql>
</source>
| |||