advanced code snippet search

Posted By

geekzspot on 01/12/13


Tagged


Versions (?)

SQL JOIN with different Columns Names

 / 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

Expand | Embed | Plain Text 
  1. SELECT * FROM employees JOIN departments ON (employees.department_id = departments.deptno);

Report this snippet  

You need to login to post a comment.