Posted By

geekzspot on 01/12/13

Tagged

1 person have marked this snippet as a favorite

/ 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.department_id AND salary > 100000);

Comment:

You need to login to post a comment.