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

1 vote294 views1 answer
Check message id sql server
SQL
7 votes310 views2 answers
Mysql default value
SQL
0 vote320 views1 answer
Sql server information_schema temp tables
SQL
0 vote334 views1 answer
How to run mysql on terminal mac
SQL
0 vote296 views1 answer
Turnicate in mysql
SQL
5 votes296 views3 answers
Sql make column nullable
SQL
15 votes301 views4 answers
T-sql drop function if exists
SQL
1 vote324 views1 answer
Table information in sql server
SQL
8 votes318 views1 answer
Sql limit results returned
SQL
0 vote315 views1 answer
How to insert a uniqueidentifier in sql
SQL