/ Published in: SQL
Note: A JOIN will only show rows that have a match in both Tables! If you want to show rows even if there is no match, then use an OUTER JOIN
- SELECT * FROM employees JOIN departments ON (employees.department_id = departments.deptno);
You need to login to post a comment.