Equi joins in oracle

SELECT first_name, job_id, departments.department_id, department_name
FROM employees, departments
WHERE employees.department_id = departments.department_id
ORDER BY last_name, job_id;

Similar codes

0 vote126 views1 answer
Sql server python connection
SQL
0 vote131 views1 answer
Cannot start database server xampp mac os
SQL
1 vote110 views1 answer
Sql not equal multiple columns
SQL
5 votes120 views1 answer
Mysql count lines
SQL
0 vote118 views1 answer
Mysql dump everythign
SQL
12 votes132 views5 answers
Sql primary key
SQL
0 vote129 views1 answer
To_date sql
SQL
14 votes125 views2 answers
Install mysqldump
SQL
-1 vote125 views3 answers
MySQL shutdown unexpectedly
SQL
0 vote116 views1 answer
Get week day name sql server
SQL