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

2 votes307 views1 answer
Mysql find tables with name
SQL
11 votes320 views1 answer
Oracle view ddl
SQL
0 vote284 views1 answer
Sql random decimal
SQL
0 vote308 views2 answers
Sql server set default value equal to auto increment
SQL
0 vote310 views1 answer
Login phpmyadmin without password
SQL
0 vote346 views1 answer
Show all sequences postgres
SQL
0 vote315 views1 answer
Fill up postgres db
SQL
0 vote337 views1 answer
Nodejs sql get one to many relationship as array
SQL
0 vote363 views1 answer
How to compile a function in oracle
SQL
1 vote305 views1 answer
Sql auto date
SQL